Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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-


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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open HTML file, but doesn't copy correctly Kmason5727 Excel Worksheet Functions 0 October 24th 08 04:47 AM
Excel 2003 does not open html file correctly rdshadden Excel Discussion (Misc queries) 0 June 7th 06 06:06 AM
From HTML open a specific worksheet within a excel file esoller Excel Programming 2 May 18th 04 09:41 PM
Open Html file i Excel Shp Excel Programming 0 December 18th 03 09:40 AM
Open file saved in HTML format Sheela Excel Programming 4 September 8th 03 05:25 AM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"