I am needing to print multiple pdf files by file name that is in a list. These files will be in the same folder as the excel file. For example MMR1234, MMR1235, MMR1236 and stop on next blank cell. Then I am needing it to close Acrobat after printing.
I have an excel file with the following data in multiple tabs. This changes daily and i print it every morning.
What I normally do is I add filters
filter by column A to show one group
Highlight the last row Bold
I repeat this process for as many groups and tabs as I have.
I want to print out some text from my form but it doesnt seem to work.
Here is the code :
Private Sub CommandButton2_Click()
Dim rapor As String
rapor = "Hello World"
rapor.PrintOut Copies:=1, Collate:=True
I dont know if this is the...