Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
followhyperlink method issue Kanan Excel Programming 0 August 20th 04 01:05 AM
Followhyperlink - How do I disable IE launch? Kenji4861 Excel Programming 5 July 11th 04 11:54 PM
FollowHyperlink Mike Archer[_3_] Excel Programming 0 December 19th 03 12:26 PM
followhyperlink Mike Archer[_2_] Excel Programming 0 December 18th 03 03:19 PM
followhyperlink failure Ron Dahl Excel Programming 2 November 4th 03 02:51 PM


All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"