Follow Hyperlink in Excel 2000
 

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?

Follow Hyperlink in Excel 2000
 

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?

Follow Hyperlink in Excel 2000
 

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?

Follow Hyperlink in Excel 2000
 

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?

Follow Hyperlink in Excel 2000
 

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?

Follow Hyperlink in Excel 2000
 

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

NickHK

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

Follow Hyperlink in Excel 2000
 

Thanks Nick, that is interesting.

I will pursue that path.


Ian



"NickHK" wrote:

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

NickHK

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