Im trying to automate the saving of Worksheets to PDF from withing VBA Excel.
Im using the print out method below.
ActiveWindow.SelectedSheets.PrintOut copies:=1
Is there any way of automating the assigning of the filename without having to manually ok the print dialog?
I have multiple workbooks with worksheets so automating this would speed things up....
thanks
Im using the print out method below.
ActiveWindow.SelectedSheets.PrintOut copies:=1
Is there any way of automating the assigning of the filename without having to manually ok the print dialog?
I have multiple workbooks with worksheets so automating this would speed things up....
thanks