Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA and HTML
From a VBA-program (EXCEL) I would like to create HTML-pages based o
worksheets generated by the same VBA-application. It is possible to save xls-files with 'save as html'. However, th layout of those generated HTML-pages is not sufficient. My question : is it possible, within a VBA-procedure, to manipulat HTML in one way or another : add HTML-tags, change tags, ... Is it possible to create and program HTML-pages from a VBA-application SaveAsHTML is definitely not enough -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA and HTML
<insert real name here
Perhaps a little more information why Save As HTML is not sufficient. If you want to do your own conversion cell by cell see http://www.mvps.org/dmcritchie/excel/xl2html.htm It does not have all the bells and whistles to make the HTML look exactly like the spreadsheet. In fact it will not convert HTML tags like < to < nor to > so that it will look the same. The advantage is that I can use Excel to generate HTML tables taking care of the <TR <TD but leaving the content alone for more complete control in Excel. It will accept object type hyperlinks but generally if you want a hyperlink you would code it as HTML in the cell. 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 "Bo_ " wrote ... From a VBA-program (EXCEL) I would like to create HTML-pages based on worksheets generated by the same VBA-application. It is possible to save xls-files with 'save as html'. However, the layout of those generated HTML-pages is not sufficient. My question : is it possible, within a VBA-procedure, to manipulate HTML in one way or another : add HTML-tags, change tags, ... Is it possible to create and program HTML-pages from a VBA-application? SaveAsHTML is definitely not enough. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
html and excel | Excel Discussion (Misc queries) | |||
Excel to Html | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) | |||
HTML in Excel VBA | Excel Programming |