PDF Creation Macro

[EGR2317]

Hello everyone,

I am using Excel 2007 and on the ribbon, I have the option to create a pdf file from a worksheet. I would like to make a macro out of this process so that the user just needs to click a button to enter the pdf creation process. Any ideas on how to code this in VBA? Any help or insight would be appreciated. Thanks in advance.

[royUK]

See here

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[EGR2317]

Thank you very much

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save