I need help in Excel export to HTML VBA.

Asked By 80 points N/A Posted on -

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.

Answered By 0 points N/A #137729

I need help in Excel export to HTML VBA.


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()



                    'convert Excel to HTML

                    Dim sheet As Worksheet = workbook.Worksheets(0)



                    'Preview HTML


              End Sub

       End Class

End Namespace




Bowen Courtemanche

Login/Register to Answer

Related Questions