I have the following script that saves a report to a PDF file. The script saves the file name as referenced in the path below: F$ = .PathSeparator & "XXXX Worksheet Report .pdf". What i would like to do is have the referenced XXXX be a call reference. The cell is in a sheet (Dashboard) cell J12, which is a four digit number. Not sure how to do that as everything I have tried has not worked so far.
Also, if I want to change the save location, which the script below saves to the desktop, how would that work. For example if I wanted to save it to a networked drive ("S:\Business\Fiscal\ACCOUNTING SECTION\XXXX Worksheet Report.pdf) how would I add that to the script.
As always any help is greatly appreciated.
Bookmarks