Saving excel file as html file

Hi Guys,

I am a newbee as far as VB is concerned. I am trying to save an excel sheet as html file from MS Visual Studio - VB, but I am getting error. A sample of my code is

Sub create_html()

Dim applicationAs Microsoft.Office.Interop.Excel.Application

Dim bookAs Microsoft.Office.Interop.Excel.Workbook

Dim sheetAs Microsoft.Office.Interop.Excel.Worksheet

Dim file_format As HtmlDocument

.....

Sheet.SaveAs("D:\Documents and Settings\Sanket\My Documents\chart.html", file_format)

End Sub()

Sanket

[1124 byte] By [SanketKhandelwal] at [2007-12-29]