Batch converting excel files to PDF - with a twist!

[Gopher_By_Fende]

hey guys,

we have at work hundreds if not thousands of invoices in excel format. they are usually printed off onto pre printed template paper, so the excel file itself has no graphics, labels etc, just the data spaced correctly.

I need to convert them all to PDF, but i need them to look like they would if they were printed onto the template paper, if that makes sense.

Does any one know how i might go about this?

Any help appriciated as usual

Gopher

 

[Gopher_By_Fende]

!!BUMP!!

Anyone?

The only way i can see at the minute is to import the data into an access database, and make a report. however this would mean importing each file one at a time, then printing each report to a pdf creator one at a time?

does anyone know how to automate this or at least do each step as a batch of all the files?

 

[Gopher_By_Fende]

i can;t find anything in distiller to let you add a background :S