macor - Save PDF in same location as excel file

[benwork]

Hi all

Im trying to save the PDF in the directory as the excel file, each month will have a separate sheet and will be in a separate directory. Instead of selecting a fixed directory, can I save the PDF in the same location as the excel file itself?

Cheers

Ben

 

[vaskov17]

are you manually saving the PDF file or do you have code that does it?

 

[benwork]

are you manually saving the PDF file or do you have code that does it?

Have code that does it, but it requires a save location. I want that save location to be the same as the excel file because it will change every month.

 

[vaskov17]

Sub SavePDF()
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ActiveWorkbook.Path & "\file.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub

 

[benwork]

Sub SavePDF()
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ActiveWorkbook.Path & "\file.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub

Thanks mate

Worked perfectly

Cheers

Ben