Printing to PDF format using CutePDF Writer in VBA

F

FastOneBaz

Hi All

I use CutePDF writer - installs as a printer so you can "print" Excel
books to PDF format.

I'd like to loop through all my XLS files in a folder and print them
all the PDF format giving them the same name as the XLS filename (with
the correct extension though).

Can this be done?

I'm comfortable with the file search and looping sections, its just the
controlling of the PDF side of things.

By recording a macro that does it on one file, it will do it but the
PDF program prompts for a filename and the Macro appears not be able to
control that window. Can I pass a parameter to the PDF program with the
filename already in it?

thanks
Barry
 

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

Top