Hi Keith,
Are you trying to generate simple HTML code, .
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2html.htm

or are you trying to interface with MS Office's verbose HTML
generator so that it looks exactly like Excel and does not adapt to
the window size In which case see the MS links on the above
page. I guess it is the second once since your example has
HtmlType:=xlHtmlStatic, _
which would be MS constant. I don't see that in the following
and maybe you are already familiiar with the articles such as:

http://support.microsoft.com/default...;en-us;q168561

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Keith Zander" wrote in message ...
I'm trying to create a script that saves a sheet in Excel
as an HTML file using VB. In Excel, the "A" column is
frozen because it contains names, the other columns ("B"
though "AI") contain the data that corrisponds to the name
in the "A" column. Since there more columns that contain
data then will fit on the screen, I need to keep the "A"
column frozen in the HTML file (so when you scroll the
side of the HTML file the stuff that was in "A" colum
stays still, similar to the way it works in Excel when you
freeze a column). I also want to keep the web page
static, so people can't edit anything.

Is there way to do this? This is what I have right now.

ActiveWorkbook.PublishObjects.Add _
SourceType:=xlSourceRange, _
Filename:="C:\bm\www\Win2k-1CPU\data.htm", _
Sheet:="Data", _
Source:="A1:AI510", _
HtmlType:=xlHtmlStatic, _
Title:="RawData"

Thanks