VBA Code to save file as PDF on sheet2 and save a copy on specific file.
This is my 1st time here and 1st post.
I got 0 knowledge on VBA code. Pertaining to the subject above, i had searched through google almost more than 8 hours. And i got this code,
Dim MyFullName As String
Application.ScreenUpdating = False
MyFullName = Left(ThisWorkbook.FullName, InStr(1, ThisWorkbook.FullName, ".") - 1)
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _
Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
Application.ScreenUpdating = True
It is working. But what i need is creating PDF through Macro command button on Sheet2, instead of sheet1. And save a copy on specific folder.
Hope that all of the experts here, willing to help me.
Thanks in advance.