'sFileName 为Html文件名
'iFNameBak 为Html存储为Excel的文件名
sub text(byval sFileName$,byval iFNameBak$)
'创建EXCEL对象
Dim iExlApp As Object
Set iExlApp = CreateObject("Excel.Application")
'存为Excel文件,iFNameBak为Excel文件名
If Dir(iFNameBak) <> "" Then Kill iFNameBak
iExlApp.ActiveWorkbook.SaveAs iFNameBak, -4143
iExlApp.activesheet.Name = sTitle
Kill sFileName
Set iExlApp = Nothing
end sub
Private Sub saveExcell_Click()
Set aa = cc.Workbooks.Open("yourpath\yourname.htm")
' ChDir "yourpath"
aa.SaveAs filename:="yourpath\yourExcellName.xls", FileFormat:=xlNormal,_
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
aa.Close
MsgBox "save as ok"
End Sub