Printing to PDF format using CutePDF Writer in VBA

  • Thread starter Thread starter FastOneBaz
  • Start date Start date
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
 
Back
Top