View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?