I need help in Excel export to HTML VBA.

Asked By Dorothy Davis 80 points N/A Posted on - 04/27/2013

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.

• Status: Open
• Question Views: 801
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Bowen Courtemanche 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()

                    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

About Bowen Courtemanche

Questions
3

Answers
17

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/01/2013
• Question Category: Visual basic