View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chijanzen chijanzen is offline
external usenet poster
 
Posts: 139
Default Openning other files from VBA

Stuart:

try ,FollowHyperlink Method


Link = "C:\work\images\preview.htm"
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True

--
天行健,君*以自強不息
地勢坤,君*以厚德載物

http://www.vba.com.tw/plog/


"Stuart" wrote:

How would i open a file such as

"C:\work\images\preview.htm"

I have been experimenting with shell but can't get anything to work

I am using Excel97 on XP home