I have a macro in Excel to delete mails older than 30 days from folders and subfolders in a shared mailbox. I have a sub for looping through each subfolder and
Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res
Can anyone explain what is happening here? I have some values in column A that I want to use with the match function. But there are some numeric values that don
Does any one know if it is possible to hook into the event when a user changes the 'From' address drop-down in Outlook 2016: I've gotten as far as testing ou
I am currently using a VBA code from Kutools that lets me combine all my worksheets into one combined "Master" sheet. However, every relevant worksheet is prece
I am trying to create a login form where the username and password input match the data on a sheet. I tried to code for if either the username or password is wr
I have a more than 1000 pdf files and I want to extract/pull data from pdf. If I use the pdf to excel conversion then it will take long time so I am trying pull
I'm trying to write a VBA to check if particular files exists in folders. For example in my code, there are 3 files that belong to folder 1, and 1 file belong t
I create a function to sum all the cells within a range as following Function SumTest(rg As Range) As Double Debug.Print "SumTest..." Dim s As Double s
I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the same row using an equation I have. if there is
I have 2 sheets named "Target Data" and "Pivot". I have filtered data in "Target Data" and now want to copy only visible cells in single cell of "Pivot" sheet.
I'm creating a Word VBA macro to insert a text frame containing an image and its caption, and then create a cross reference to it in the main document text. B
I have to pass data from Access database to a MySQL database attached to HeidiSQL automatically every minutes. To do that i put the data into excel files format
I have a function that aims to return the visible cells (as a range) after applying an autofilter to an inactive worksheet; the autofilter data is represented b
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a form that is selecting emails based on companies that have expired insurances. Some companies have both a Business and personal emails whilst others ha
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
I generate an email in vba and send it. I have a class which includes the send event for that email so I am able to tell if the email has been sent. My issue is
Is there a way to tell if some dynamic array, for example arr() as String is initialized? IsEmpty and IsNothing seems not to work with dynamic arrays. Currently