File Saving as excel and PDF

[nick6996]

Hi is it possible, when i save my worksheet its saves as an excel file but at same time creates a PDF aswell

Thank you

[JohnTopley]

You can "Save as" your file as PDF.

[nick6996]

Hi john thanks

But i mean is it possible if i click save, it then saves it as an excel file but then at the same time a PDF, so i dont have to save it twice.

Im doing a job order sheet which then fills out a delivery not and invoice but my Boss wants to save the excel but then it create PDFs all at the same time is that possible

[JohnTopley]

You will need a VBA macro to do that.

[nick6996]

No idea what that is sorry i'm only a basic mans for excel