| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you close acrobat reader using excel VBA
I'm able to use excel to peint the PDF files, buit would like to know the
command in VBA to close the application once the printing is complete. also for powerpoint also Thanks -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you close acrobat reader using excel VBA
Maybe you can send ctrl-Q in a sendkeys statement.
QuietMan wrote: I'm able to use excel to peint the PDF files, buit would like to know the command in VBA to close the application once the printing is complete. also for powerpoint also Thanks -- Helping Is always a good thing -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you close acrobat reader using excel VBA
any idea on the syntax???
-- Helping Is always a good thing "Dave Peterson" wrote: Maybe you can send ctrl-Q in a sendkeys statement. QuietMan wrote: I'm able to use excel to peint the PDF files, buit would like to know the command in VBA to close the application once the printing is complete. also for powerpoint also Thanks -- Helping Is always a good thing -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you close acrobat reader using excel VBA
Well, Tom used:
Application.SendKeys "^p~", False to print So maybe something like: Application.SendKeys "^Q~", False QuietMan wrote: any idea on the syntax??? -- Helping Is always a good thing "Dave Peterson" wrote: Maybe you can send ctrl-Q in a sendkeys statement. QuietMan wrote: I'm able to use excel to peint the PDF files, buit would like to know the command in VBA to close the application once the printing is complete. also for powerpoint also Thanks -- Helping Is always a good thing -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you close acrobat reader using excel VBA
http://puremis.net/excel/code/083.shtml
But, he says the /t switch didn't work for him and I found another post that sys it quit working starting with acrobat 5.0. Apparently it works in version 4 if you have that on your computer. -- Regards, Tom Ogilvy "QuietMan" wrote: any idea on the syntax??? -- Helping Is always a good thing "Dave Peterson" wrote: Maybe you can send ctrl-Q in a sendkeys statement. QuietMan wrote: I'm able to use excel to peint the PDF files, buit would like to know the command in VBA to close the application once the printing is complete. also for powerpoint also Thanks -- Helping Is always a good thing -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Shell to Acrobat Reader | Excel Programming | |||
| Opening Acrobat Reader using VBA | Excel Programming | |||
| Opening Acrobat Reader using VBA | Excel Discussion (Misc queries) | |||
| Print Acrobat Reader PDF file from VBA | Excel Programming | |||
| how sendKeys to Acrobat Reader | Excel Programming | |||
Hybrid Mode
