Hi, I searched all trough the forum and google'd it but I can't seem to find the code that let's you save an excel sheet as HTML.

Could anyone help me out on this one ?
I mean I'm only looking for the simple command to save as html, for instance:

Code:

Dim $ExcelSheet
$ExcelSheet = CreateObject("Excel.Sheet")
$ExcelSheet.Application.Visible = 0
$ExcelSheet.Application.Cells(1, 1).Value = "This is column A, row 1"
$ExcelSheet.SaveAs("D:\TEST.XLS")

But it would be something like:
Code:

$ExcelSheet.SaveAsHTML("D:\TEST.HTML")