Help with PDF Printer

[screaming oranges]

I have this kick-ass excel macro that is basically capable of cutting down a multi-hour job into a couple of minutes. However, I'm at a loss in the end.

The last stage of the macro runs a mail merge through excel as it calls the next client, changes address, adds other personal info, prints the job, and saves it as an individual file.

My problem is that I can get the individual files to save under, say, date and client's name as an excel spreadsheet, but I'd really like to save as a pdf file. I am aware of various programs that act as a printer and basically let you save through the print dialog. The issue is, they always prompt for a name and location.

Anyone know of a pdf converter that can use an excel cell as the filename, thereby bypassing the print job prompt screen? Preferably free. =/

[Beefy]

I have no idea whether it can do what you want, but I use PDF Creator to make PDFs. At the very least, it might be worth investigating.

[screaming oranges]

thanks beefy.

also, to clarify, i am aware that excel 2007 has a plugin from microsoft that lets you save as a pdf, but at work we have 2003, so that's a no go.

Hmm, beefy, it seems that pdfcreator has a COM interface! this means i can call it up in the macro. i'll try it later, as i have to go run some errands. If anyone has other ideas, please share!