Macro specifying file name when printing to PDF?

D

Don Wiss

I have Excel 2002 and Acrobat Pro v.8 on my machine. My macro can print to
a PDF file, but a dialog box pops up asking for the filename. The macro
knows the folder and filename it wants to save as. How can I specifying
them in the macro so I don't have to manually enter them?

Don <www.donwiss.com> (e-mail link at home page bottom).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Images are pixelated when saving to PDF 0
Include Layout name with filename when printing to PDF 0
Macro to Publish as PDF 1
Button to print XLS file as PDF 0
Don't want to hard-code file name in macro 3
Problem when publishing to PDF 0
Macro Code for bringing up Save As dialog box and changing file Type 0

Top