Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel to PDF
Message
From
29/08/2003 12:28:38
 
 
To
29/08/2003 12:21:56
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00824603
Message ID:
00824609
Views:
18
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform