Openning other files from VBA
 

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

Openning other files from VBA
 

Why not just open it in Excel, as any other file?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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