RE: [PHP-WIN] OLE/COM stuff - let's have some fun with Word andAcrobat!

try the sendkeys VBA function like : Dim ReturnValue, I ReturnValue = Shell("CALC.EXE", 1) ' Run Calculator. AppActivate ReturnValue ' Activate the Calculator. For I = 1 To 100 ' Set up counting loop. SendKeys I & "{+}", True ' Send keystrokes to Calculator Next I ' to add each value of I. SendKeys "=", True ' Get grand total. SendKeys "%{F4}", True ' Send ALT+F4 to close Calculator. I've got it straight out of Access97 help :) According to the MSDN it should be availlable in both VBA en VB script. -----Original Message----- From: Asendorf, John [mailto:JAsendorf@lcounty.com] Sent: Tuesday, October 10, 2000 8:42 PM To: Php-Windows (E-mail) Subject: RE: [PHP-WIN] OLE/COM stuff - let's have some fun with Word andAcrobat! OK, I'm most of the way there, I think. I have started a macro... but it requires some interaction and I don't know VB well enough to fix it. It starts with opening the document (probably to be done in PHP) then prints the document using the PDF Distiller or PDF Maker (problem exists using either)... then it asks for a Save As name and location (Save As dialog box) which then requires a user interaction. The default is fine... How do I tell the macro to go ahead and save (like a user pressing the [Save] button"? --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 > -----Original Message----- > From: alain samoun [mailto:alain@samoun.com] > Sent: Monday, October 09, 2000 3:38 PM > To: 'Andy Hoffman'; 'PHPWINDOWS' > Subject: RE: [PHP-WIN] OLE/COM stuff - let's have some fun with Word > andAcrobat! > > > Originally, the idea is to see if PHP COM can be used to solve John's > problem. I just checked and can't see any COM object for > PdfMaker in Word. > But there is the possibility to write a macro that would do > the job, then > run the macro from PHP COM. John try that if you wish and see > how it works, > let us know... > Alain > > Message from Alain Samoun > alain@samoun.com > HEAR ME>> http://pagoo.com/signature/alain > > > -----Original Message----- > From: Andy Hoffman [mailto:andy.hoffman@bms.com] > Sent: Monday, October 09, 2000 11:48 AM > To: 'PHPWINDOWS' > Subject: Re: [PHP-WIN] OLE/COM stuff - let's have some fun with Word > andAcrobat! > > > alain samoun wrote: > > > Yes, can't use COM with Linux at this point ;) > > Also I think that Distiller only 'distill' postscript files. > > Well, yes & no... as Distiller Assistant is a print driver > that runs on the > machine where Acrobat 4 (or earlier) is installed, and you > can print from > any > application into Distiller (the print driver prints from the app to a > postscript > file, and then Distiller reads the postscript file into a PDF > format) - all > in > one simple action. As far as "badly formatted" results... > Acrobat doesn't > seem > to like GIFs when generating PDF files... if your document > contains GIFs or > JPEGs, it's best to convert these to BMPs before creating > your PDF file :) > > Well, I digress, as I've taken this thread now completely out > of the realm > of > PHP - sorry folks :( > > -- > Andy Hoffman > Web Developer > Bristol-Myers Squibb > email: andy.hoffman@bms.com > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net