Macro to print a fixed area to PDF

[Student1990]

Hello,

I have a worksheet where the print area never changes: its always A1:O100. I want to add a button that runs a macro onto the worksheet, and I want the macro create a PDF of this worksheet. I know I could just as easily create a PDF manually, but I'm curious if there's a way to use a macro to complete the process. Any suggestions/advice would be great. Thanks in advance!

[Fotis1991]

Hi

See this article. Describes what you want to do but for Excel 2010. See if works in 2007 too.

http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

[Student1990]

I took a look and I'm going to try some things. Not sure if I should mark the thread as solved or not, so I'm going to leave it open and post on here if I come up with a solution. If someone prefers that the thread be marked as "solved" feel free to close it. Thank you!