A
Abi0207
Guest
In windows form need to export data from excel to HTML. I am trying as below but getting "Public member 'NamedaRanges' on type 'Worksheet' not found" in namedRanges. Not able to verify after that whether it will save HTML successfully. Please help to solve this.
'''
Private Sub Button_click()
xlSheet=xlWB.Worksheets("Sheet3")
xlSheet.NamedRanges.SetPrintArea(xlSheet.Cells.GetSubrange
("A1",C1"))
xlSheet.SaveAs(FileName:="C:\Users\ Sample.html", FileFormat:=xlHtml)
End Sub
'''
Continue reading...
'''
Private Sub Button_click()
xlSheet=xlWB.Worksheets("Sheet3")
xlSheet.NamedRanges.SetPrintArea(xlSheet.Cells.GetSubrange
("A1",C1"))
xlSheet.SaveAs(FileName:="C:\Users\ Sample.html", FileFormat:=xlHtml)
End Sub
'''
Continue reading...