How to open an html file from within a macro
 

Excel 2002
Windows XP Pro

Ideally what I'd like to do is open an html file from within a macro, and
I'd like to specify that the html opens with IE. Is this that hard to do?

Sub MyMacro()

'Code to open html file using IE

End Sub


Would it be easier to open a text file (Notepad) than an html file?

Any help appreciated.

-gk-



================================================== ======================
"The creative act is not the province of remote oracles or rarefied
geniuses but a transparent process that is open to everyone."
-Greg Kot in Wilco Learning How To Die-

How to open an html file from within a macro
 

have you tried something like

Shell "Start mydoc.htm"

--
Regards,
Tom Ogilvy


"38N90W" wrote in message
...
Excel 2002
Windows XP Pro

Ideally what I'd like to do is open an html file from within a macro, and
I'd like to specify that the html opens with IE. Is this that hard to do?

Sub MyMacro()

'Code to open html file using IE

End Sub


Would it be easier to open a text file (Notepad) than an html file?

Any help appreciated.

-gk-



================================================== ======================
"The creative act is not the province of remote oracles or rarefied
geniuses but a transparent process that is open to everyone."
-Greg Kot in Wilco Learning How To Die-