Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 675
- Office Version
- 365
- Platform
- Windows
I have this code:-
Sub pdfInvoice()
'
' pdfInvoice Macro
'
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, PrintToFile:=True, Collate _
:=True, IgnorePrintAreas:=False
End Sub
But I want it to save to a specific location & as the 'saved file' name will change upon each print, can it use a a cell ref (ie save to c:\data\cell d2+e2+f1+g1.pdf
MTIA
KR Trevor3007
Sub pdfInvoice()
'
' pdfInvoice Macro
'
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, PrintToFile:=True, Collate _
:=True, IgnorePrintAreas:=False
End Sub
But I want it to save to a specific location & as the 'saved file' name will change upon each print, can it use a a cell ref (ie save to c:\data\cell d2+e2+f1+g1.pdf

MTIA
KR Trevor3007