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" wrote:

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

NickHK

"IanC" wrote in message
...
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".

"Tom Ogilvy" wrote:

so give a few samples of res_link

--
Regards,
Tom Ogilvy

"IanC" wrote in message
...
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?