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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stuart" <jtfder@lkbrt.kfe> wrote in message
news:dnbgco$dr7$1@news8.svr.pol.co.uk...
> 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
>
>
>

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
>
>
>
>