macro to prit to pdf

R

Renato

Hi,
I am trying to save excel sheets as pdf with a macro that uses excel 2000-3
and acrobat 7.0 elements.
It all works fine if I do manual input of the filename in the print window.
But I don't know how can I pass to acrobat elements the file name through
VB. Infact if I specify filename in the PrintOut method, this name is not
passed to acrobat elements, but used for postscript out.
I read about assing filename through registers but I have nevere tried this.
Is there someone that can say me how can I solve this issue?
Thanks,
RS
 

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
Drop down list control value in vba 2
Include Layout name with filename when printing to PDF 0
excel 2003 macro that use acrobat Elements 1
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Images are pixelated when saving to PDF 0
Macro specifying file name when printing to PDF? 0
Button to print XLS file as PDF 0

Top