FollowHyperlink to OLEObject
I have an OLEObject (PDF file) embeded in my workbook which I am activating
by using the following code: Worksheets("Help").OLEObjects("HelpFile").Activate It is working but not exactly I would like it to be. If Acrobat Reader is not opened before executing this line I am receiving the error message. To fix it I have added the error handling line which will continue the code from next line. Now error is hiden but Acrobat window is behind Excel window and user need to switch windows manually. Is it any way to bring this Acrobat window on the top after executing this part of the code ? I am looking for alternative solution - to use FollowHyperlink. Is it possible to use FollowHyperlink to call the OLEObject embedded inside the workbook ? If yes, how ? Thanks for help. Tony |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com