Hi… I would want to create a sub to export a sheet excel to HTML file. From excel I have recorded the macro while I made “file - saves as page web” and this is the code that has created:

With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, "C:\Page.htm", _
"Report", "", xlHtmlStatic, "Report_28311", "")
.Publish (True)
.AutoRepublish = False
End With

I inserting this code on VB6, but does not work.
Someone can help me to arrange this partof code in order to make it to work in VB6?
Thanks