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