FollowHyperlink

Expel

Board Regular
Joined
Nov 6, 2002
Messages
83
Hi Folks

I have been using the FollowHyperlink method to open documents from Excel and Access 2000, but having upgraded to 2003 I find that while Office documents open fine with this method, .pdf documents just will not open.
Sometimes Acrobat will open, but no document and other times I assume Acrobat opens with a flash on the screen and closes immediately.

The code has not changed as the files were created in Office 2000 (or maybe 97)

Anybody come across this discriminatory behaviour and managed to make it work?

Regards
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Most such applications will open with filenames supplied like
Excel.exe MyFile.xls
application - space - filename

We usually need to include the full paths to both. Perhaps you can do this with your links.
 
Upvote 0
Thanks for the suggestion, but the type of file is variable, so the file needs to be opened in its associated application.

This all worked OK before, I'm just not sure why it fails (with no errors) since the upgrade.
 
Upvote 0
There may still be scope for using a method similar to my suggestion. Come back with some more detailed information if you wish.
 
Upvote 0

Forum statistics

Threads
1,216,515
Messages
6,131,108
Members
449,620
Latest member
MatXm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top