Printing Excel Workbook (24 sheets) to PDF - macro or vba?

[robbertly]

Hello,

I have an Excel Workbook with 24 sheets.

I want to create a single pdf document from this workbook.

I know that each single excel sheet in the workbook will return 30 A4 pages when printed in pdf.

I want to save the document with the name Numbers.pdf in a folder called Numbers ideally on my desktop or on the C: drive if it needs a location.

Any suggestions on how this can be achieved?

Thanks,

Robert

 

[mole999]

macros and visual basic for applications are really the same thing in excel

you can record most of your actions with the macro recorded, then post your code here between code tags