View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony tony is offline
external usenet poster
 
Posts: 313
Default 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