I have this code
This works great, but it saves the .PDF to the location of the master file. How can I get it to save to my Desktop, for example?![]()
TimeFileName = ActiveWorkbook.Path & Application.PathSeparator & TimeFileName ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=TimeFileName, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False
Bookmarks