Save as HTML

[John Hayes]

Can anybody tell me why it is that when I RECORD MACRO tit does not pick up
on Save As HTML at all.

I was recording with a view to seeing what the code for this is but it
doesn't show up in the recorded MACRO and also, if I rerun the MACR it
doesn't execute the Save As HTML command.

Anybosy know how to code this?

Regards

John

[Nick Hodge]

John

This is really only half an answer, but the 'SaveAs HTML' functionality in
XL97 (I presume that's what you have), was provided by add-in. (Not a very
good one at that). This is why it doesn't record. I've had little to do
with HTML, so can't help you with the coding, but would tell you, if this is
important to you, that XL2000 handles all aspects of web-authoring, HTML,
etc, much, much, much better than 97. The only drawback in 2000 though, is
that most of the 'neat' features can only be shown using IE5, but as that's
free, it shouldn't be too big a drawback.

--
HTH
Nick Hodge
Southampton, England
nick_...@lineone.net

John Hayes <jhay...@gofree.indigo.ie> wrote in message
news:tWwS3.573$pK5...@news.indigo.ie...

[Tom Ogilvy]

Here is some additional info which should get you started.

http://officeupdate.microsoft.com/downloadDetails/html.htm
Internet Assistant Wizard Update for Excel
when loaded, this provides the ability to export to html in Excel 97. That
capability was introduced with SR1, so I don't know if this will work with
the original XL97 or not. XL2000 has a saveas option for html.
This download has sample files and documentation on programmatically saving
as HTML.

http://support.microsoft.com/support/kb/articles/Q187/3/58.ASP
XL97: Internet Assistant Update Does Not Include XLHTML.DLL

http://support.microsoft.com/support/kb/articles/Q168/5/61.asp
XL97: How to Programmatically Save a Worksheet as HTML

http://support.microsoft.com/support/kb/articles/Q172/3/05.ASP
XL97: LastUpdated Argument of Htmlconvert Is Not Functional

http://support.microsoft.com/support/kb/articles/Q170/2/27.ASP
XL97: Internet Assistant Wizard Doesn't Recognize All Files

http://support.microsoft.com/support/kb/articles/Q162/0/27.asp
XL97: "Save As HTML" Does Not Create Some Tags

http://support.microsoft.com/support/kb/articles/Q163/1/03.asp
How to Create a GIF File from a Microsoft Excel Chart

http://support.microsoft.com/support/kb/articles/Q169/0/22.ASP
XL97: Conditional Formatting Not Saved When Saving as HTML

http://support.microsoft.com/support/kb/articles/Q158/0/79.asp
XL97: How to Use the Internet Assistant Wizard

http://support.microsoft.com/support/kb/articles/Q147/2/73.ASP
XL: The Internet Assistant Wizard (Html.xla) xl5/95

http://support.microsoft.com/support/kb/articles/Q169/0/55.ASP
XL97: Insertion Code for Internet Assistant Is Case Sensitive

http://support.microsoft.com/support/kb/articles/Q169/1/05.ASP
XL97: Error Running Wizard When a Control Is Active

http://support.microsoft.com/support/kb/articles/Q170/3/09.ASP
XL97: Named Locations in Hyperlinks Missing After Saving as HTML

Regards,
Tom Ogilvy

[Nick Hodge]

Tom

Do you store all these references somewhere? <g>

--
HTH
Nick Hodge
Southampton, England
nick_...@lineone.net

Tom Ogilvy <twog...@email.msn.com> wrote in message
news:#8pH3VtI$GA.276@cppssbbsa04...

[Tom Ogilvy]

As a matter of fact, I do. I use them too.

Regards,
Tom Ogilvy

Nick Hodge <nick_...@lineone.net> wrote in message
news:eg8AJbtI$GA.248@cppssbbsa05...