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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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.
 

Expel

Board Regular
Joined
Nov 6, 2002
Messages
83
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.
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
There may still be scope for using a method similar to my suggestion. Come back with some more detailed information if you wish.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,113
Messages
5,835,456
Members
430,357
Latest member
Greshapa

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
Top