Follow Hyperlink in Excel 2000

[Guest]

I am using the following line of code to open Word and PowerPoint documents
from within Excel:

ActiveWorkbook.FollowHyperlink Address:=res_link, _
NewWindow:=True

where 'res_link' is the directory and name of a file that is picked out from
an Excel cell.

This code works perfectly in XP and 2003, and I thought that I had also run
it on 2000. However, I am now unable to get this code to run within Excel
2000.

Does anyone know if there is something different in the way that the
FollowHyperlink command needs to be used within the older system?

 

[Tom Ogilvy]

so give a few samples of res_link

 

[Guest]

Many thanks.

This would be a typical link:

G:\Research\2005\Presentation Mar data.ppt

However, I have also tried without success a simple

ActiveWorkbook.FollowHyperlink Address:= "C:\Ian.ppt".

 

[NickHK]

Ian,
FollowHyperLink work fine for me in XL2000.
What happens when you run this code ?
Nothing, error, ??

NickHK

 

[Guest]

I get the -2147221014 message, suggesting it cannot find the file or the
path. Your success is making me think there is a problem with my system as
opposed to the code.


Ian

 

[NickHK]

Ian,
I get that error if the file name is not valid.
Error 432 if the path is not valid.

NickHK

 

[Guest]

Thanks Nick, that is interesting.

I will pursue that path.


Ian