How to make excel file auto save to PDF office 2010

Hi everyone
I have workbook I would like to auto save to PDF copy file in different location every time the original file is save maybe some VBA code is this possible ???

Thanks in advance

Shane

Hello Shane,

Add this macro to your ThisWorkbook module. Change the file path and name to what you will be using.

Please Login or Register  to view this content.

hi thanks for your help i seem to be get error with this code i have highlighted in the code showing were it say's im getting compile error also having trouble entering a file name to work

cheers
p.s sorry for being a pain

Please Login or Register  to view this content.

Hi,

It works for me if set out as

Please Login or Register  to view this content.

i.e. without the parentheses either side of the .Export......code and with the .Export.... as a new line

Should be:

Please Login or Register  to view this content.

Besides, if you set a print area, make sure to set "IgnorePrintAreas" to "False".

Last, but not least, I combined some code I found elsewhere with the code in this forum. That way my PDF file saves in the same location as the Excel file without having to set the path, manually. Next to that, the PDF file only contains the print area of the active worksheet, instead of the whole Excel file :

Please Login or Register  to view this content.