Hi. I'm new to this and I need your help. I have an entire workbook in xls file format that I would like to export to HTML using Visual Basic. I use Microsoft Excel and Visual Basic 6. I need help in Excel export to HTML VBA. Thanks in advance.
Hi Dorothy
Â
Â
You can apply the following code for VB to convert the file into HTML VB :
Imports Spire.Xls
Namespace Xls2Html
Â
      Class Program
             Private Shared Sub Main(args As String())
                   'load Excel file
                   Dim workbook As New Workbook()
                   workbook.LoadFromFile("….test.xls")
Â
                   'convert Excel to HTML
                   Dim sheet As Worksheet = workbook.Worksheets(0)
                   sheet.SaveToHtml("sample.html")
Â
                   'Preview HTML
                   System.Diagnostics.Process.Start("sample.html")
             End Sub
      End Class
End Namespace
Â
Â
Regards
Bowen Courtemanche
