ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,934
- Office Version
- 2007
- Platform
- Windows
Using the command button to save a file of which the extension is pdf i see the following error.
Ive checked the folder is there & also the path to the folder & both are correct but im unaware as to what the issue is.
Checking the code when i debug i see this line in yellow.
Ive checked the folder is there & also the path to the folder & both are correct but im unaware as to what the issue is.
Checking the code when i debug i see this line in yellow.
Rich (BB code):
strFileName = "C:\Users\there\Desktop\REMOTES ETC\DR\DR COPY INVOICES\" & Range("L4").Value & ".pdf"
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, fileName:=strFileName, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False
End With 'CURRENT INVOICE IS NOW SAVED