Saving a copy as PDF by saving the XLS file

[Greg_dd]

Every time I hit save in my excel (.XLS) document, I would like it to save a copy as .PDF.

I would like to be able to specify what directory the PDF is saved in (ideally it would be different from the directory that the .XLS file is in).
The PDF file name should be the same every time and overwrite the existing one each time.

I am using Excel 2010 and I do know how to implement VB in excel. Thank you for your time.

 

[DuaneR]

small world i am looking for code to do the exact same thing. have not had much luck i am working with this.

sFileName = "http://sharepoint/electrical/Over Time Spreadsheet/OTLog.pdf"

' Save the File as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
sFileName, Quality _
:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True

i plan to use this with Workbook_BeforeClose

 

[DuaneR]

no one out there tried this before?