I have a userform with a TreeView being used as a "Drag and Drop" file input. The goal is to have the userform automatically accept that file and copy it to a specified folder.
So far i have this code in my userform_activate:
TreeView1.OLEDropMode = ccOLEDropManual
So I have a folder labeled "Weekly" with 6 different emails with "Scheduled Report" somewhere in the subject line. I need to create a macro that will copy each of those different sheets and paste them as different tabs in a specific excel workbook labeled "Revenue".
I then wanted to label each...
Hey everyone !
I'm seeking your help because I can't seem to find a solution on the net.
I use a macro to send emails automatically, and I need to attach a different file to the emails.
The only way I found is to specify the file's location, however, since that file changes every week, I...
I really need your help. I am new to this whole VBA coding thing have no basic at all in programming and stuff so please help me out here. I am currently assigned a project where I have to create a excel sheet which act as a templete for sending request. The requirement of the...
I have code (see below) to send an email automatically if a button is pressed at it has been 30 days since the last time is was pressed. I am trying to attach the spreadsheet to the email but I am having no luck.
This is the code I'm using:
Private Sub CommandButton1_Click()
Dim OutApp As...
I need some help!!
I declared 4 variables as string file1, file2, file3 and file4
then I assign the value of each cell to the respective value
file1 = Cells(9, "C").Value ' Set the first file to attache
file2 = Cells(11, "C").Value ' Set the Second file to attache
file3 = Cells(13...