Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel to PDF
Message
De
29/08/2003 12:28:38
 
 
À
29/08/2003 12:21:56
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00824603
Message ID:
00824609
Vues:
17
>I have a project coming up that will require me to take a few hundred XLS files and convert them to PDF. I was wondering if anybody had suggestions as to the best way to go about this?

If Excel is installed, and you know the filenames (*.xls) in advance, and you have a PDF writer (Adobe, Amyuni, etc.) then you could write a loop with Adir() and For..Next using Excel automation to set the printer to the PDF driver and print each file. You do not have to make Excel visible or anything. Just instance and send file to printer.

I do not know if you can send an XLS file to print directly from Windows (maybe with WinAPI or WSH), without using COM Automation, but that may be another idea to investigate.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform