Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 191
- Office Version
- 2019
- Platform
- Windows
Hello everyone!
I've got this macro to save as PDF, that worked fine on my other computer (office 2019). I transferred my excel file to another computer (office 2003) and I get a debug error, highlighting the whole macro as yellow. The folder I want it to be saved is C:\Users\sogiano\Desktop\Απαντήσεις\ and the filename is at AH1.
Thank you in advance!
I've got this macro to save as PDF, that worked fine on my other computer (office 2019). I transferred my excel file to another computer (office 2003) and I get a debug error, highlighting the whole macro as yellow. The folder I want it to be saved is C:\Users\sogiano\Desktop\Απαντήσεις\ and the filename is at AH1.
Thank you in advance!
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:="C:\Users\sogiano\Desktop\Απαντήσεις\" & Range("AH1").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True