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 application As Microsoft.Office.Interop.Excel.Application

Dim book As Microsoft.Office.Interop.Excel.Workbook

Dim sheet As 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()

Do I need to 'Add Reference' for the project ? What should be done ?

thanks,

Sanket