Peter Hart wrote: > Hi Michael > > Sent direct to mbabcockatmbsoftwaresolutionsdotcom > > As you will see from the code I pick up the PDF Creator Printer and > using windows scripting change the default printer to that. > On finishing I change the default printer back to what it was. The > problem is that if I save what Excel says is the default printer and > then try and set back to it, the variable used holds something like > "OK5600c on NE001:" > I then used APRINTERS() to see what windows says it is and had the same > problem i.e. Windows Scripting says it cant set the printer as no such > printer exists. I have to Look fro NE plus numbers and use a STRTRAN to > get rid it then works, in the code you will see I look for the whole > Printer name and change it. But I can't do this at the clients site. > The first I knew there was a problem was when there IT chap said they > were all complaining that there printers wouldn't work and he was having > to change them back to default in start/settings/printers. > Cheers
At the least, you could put a messagebox in there telling the user to change the default printer over to PDFCreator and then run against the default, right? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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/[email protected] ** 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.
