ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening Acrobat Reader using VBA (https://www.excelbanter.com/excel-programming/351626-opening-acrobat-reader-using-vba.html)

vetron

Opening Acrobat Reader using VBA
 
I have added the:
"Adobe Acrobat 7.0 Type Library"
under tools and references.

This is the only Adobe Product I have in my PC.

I get an error 429 which says ActiveX component cant create object.

Can you help me with this problem?

Gary''s Student

Opening Acrobat Reader using VBA
 
This will open the reader:

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.pdf", 1)
End Sub

--
Gary''s Student


"vetron" wrote:

I have added the:
"Adobe Acrobat 7.0 Type Library"
under tools and references.

This is the only Adobe Product I have in my PC.

I get an error 429 which says ActiveX component cant create object.

Can you help me with this problem?


vetron

Opening Acrobat Reader using VBA
 
Ok. It works, but I cant control Adobe, unless I use "SendKeys".
I am trying to open and control Adobe.


"Gary''s Student" escreveu:

This will open the reader:

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.pdf", 1)
End Sub

--
Gary''s Student


"vetron" wrote:

I have added the:
"Adobe Acrobat 7.0 Type Library"
under tools and references.

This is the only Adobe Product I have in my PC.

I get an error 429 which says ActiveX component cant create object.

Can you help me with this problem?



All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com