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

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

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

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

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