Merge in Excel, Save in PDF with CutePDF Writer or Microsoft’s PDF Add-In...

[DONDIEGO]

Hello

I want to:

- merge in Excel

The sheet "Busfiche" gets it's information throughout the other sheets by filling in the fields "Huidig record" (actual record) / "Eerste te printen item" (first item to print) / "Laatste te printen item" (last item to print)

for example:
Huidig record (actual record): 39
Eerste te printen item (first item to print): 39
Laatste te printen item (last item to print): 42

- save AUTOMATIC the files in PDF-format with their recordnumber in c:\MyData

so: "Busfiche_39.pdf"; "Busfiche_40.pdf"; "Busfiche_41.pdf"; “Busfiche_42.pdf”

- but: I only can (may - businesspolicy...) use CutePDF Writer or use Microsoft’s PDF Add-In

Can someone help me please?

DonDiego

[Ken Puls]

Hi Dondiego, and welcome to the forum!

I posted a blog article some time ago on using the Microsoft PDF add-in. You can find that here: http://www.excelguru.ca/blog/2008/01...-pdfxps-addin/

Let me know if you need any more help with it.