SaveAs PDF Dialog Box

I have a workbook with a couple of commandbuttons for saving and printing pdf files. Paul got me fixup
on the SaveAs problem I was having, one more problem. When I save a workbook it becomes that name and then I print out pdf
file. When I save the file it shows up in the print dialog box to save, if I skip the save as button and just want the pdf file I have to type in the name. Here are my two codes,is it possible to have the pdf dialog box show the value in c16 without saving first.

Please Login or Register  to view this content.

PDF Button Code

Please Login or Register  to view this content.

Thanks

If you had Excel 2007+ you could simply use the SaveAs PDF option built into the newer versions of Excel. With Excel 2003 you're stuck with CutePDF, pdfCreator or Adobe Acrobat (or other). Apparently CutePDF (the non-pro version) doesn't allow access to its interface using VBA, but pdfCreator (free) does.

See examples here:
http://www.excelguru.ca/content.php?...Early-Binding)
http://www.excelguru.ca/content.php?...-Late-Binding)

Here's another user (different forum) that has a similar problem and their discussion:
http://www.ozgrid.com/forum/showthread.php?t=51635

Hope that helps!

It should. If you record a macro while saving the file as PDF you can see the code it creates, e.g.

Please Login or Register  to view this content.

There are other options as well (saving only a selection as PDF, the entire workbook (all sheets) as PDF, etc.). Here's some info: http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Also, your profile lists Excel 2003. Does that need to be updated? If so, click "My Profile" at the top of this page, then select the "About Me" tab in the profile. Click the small pencil next to My Microsoft Office Version.

If you add a reference to C16 it should work. Also change the file path to your actual file path. Example:

Please Login or Register  to view this content.

Hmm, with some fiddling I may have figured this out..

Please Login or Register  to view this content.

This will open the SaveAs dialog window with the filename from cell C16 on Sheet1, set to save as PDF. You can then choose where to save the file.

Thanks to these two sites for the info:

http://social.msdn.microsoft.com/For...6-46630bc02f95 (in Phil Hoff's reply)
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx (PDF fileformat type in comments at very bottom)