Hi Michael Do you want me to send you the bit of code I use to create my purchase order and then print to pdf. This use the PDF Creator printer driver. In your case the Excel Files are already created so you just need ADIR() or something similar to pick up the files to print and then loop through sending them to PDF Creator. The only problem I have is that Excel picks up the default printer as XXXX on Ne0X: and sometimes this is not recognised when the program tries to restore it. You could probably ignore that bit of code and just reset the printer manually. It should not be too hard to create a macro in excel and let the user just click a button. Just reverse the code to the VBA equivalents. In fact the reverse of what I do to get my VFP code, Open Excel, record a macro to do what I want VFP to do. Copy and paste the code into VFP and then change it were VFP's Syntax is slightly different.
Cheers Peter Peter Hart Computers On Behalf Of MB Software Solutions,LLC Sent: 03 September 2009 23:00 Subject: Need ideas for Excel to PDF automation My coworker asked if there's a way to address this problem: his user has about 200 excel documents that need to be made into PDFs....and this will happen about once per month, so it's ongoing. Paul had suggested office automation, and that sounds like it will work provided we use something like the PDFCreator printer driver, but I'm asking here for any other suggestions as well to present. tia! -- Mike Babcock, MCP _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a57fa4cf19531343a2ee11b57db8e3af04c...@server.peterhartcomputers.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
