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
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.aspx?scid=kb;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" <KZs_...@yahoo.com> wrote in message news:004a01c368d2$e9d5a720$a501...@phx.gbl...
I'm trying to create a VB script that can save a sheet in
workbook as a web page. I'd like the page to look exactly
like it would look in excel (frozen frames, column width
etc), but also be static (non-editable).
It's also important that the web page not be dependent on
the user having excel installed. I've tried setting the
HtmlType to xHtmlCalc, and that gives me the frozen frames
I need, but it makes the web page dependent on having
excel installed. Plus it puts a lot of excel editing
stuff at the top of the page that I don't want to be
there. The way the web page looks with HtmlType set to
xHtmlStatic is ideally what I want, I just need the frozen
frames to be available.
I tried htmlconvert function in the link at the bottom,
but I don't think the htmlconvert function is available in
Office XP (unless I'm doing something wrong). When trying
to use the HTMLconvert, it says the sub or function not
found. I tried opening HTML.xla up to see which functions
were available, but it is password protected.
Thanks
Keith
>.
>
Go back to my page
> Excel to HTML conversions
> http://www.mvps.org/dmcritchie/excel/xl2html.htm
look in the related material for the remove office components.
The Office 2000 HTML Filter 2.0 (Download Center) will remove all
Office 2000 extra formatting tags from an HTML file.
http://office.microsoft.com/downloads/2000/Msohtmf2.aspx (valid on 2002-11-08)
and believe it or not that link is still valid.
---
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" <KZs_...@yahoo.com> wrote in message news:022a01c36b1d$aa88edf0$a101...@phx.gbl...