Sub marco1() ActiveWorkbook.SaveAs Filename:="c:\a.xml", FileFormat:=xlXMLSpreadsheet End Sub
ActiveWorkbook是什么类型的??
加入microsoft excel object library 的引用 再 dim excelApp as excel.application set excelApp= new excel.application excelApp.open fileName这时候 activeWorkBook 就可以用了 activeWorkBook指的是 当前打开的excel文件!
先用 ADO打開Excel,再用Save方法保存為XML Dim Cn as ADODB.Connection Dim Rs as ADODB.RecordSetSet Cn=new adodb.connection cn.open "Driver={MicroSoft Excel Driver (*.xls)};DBQ=D:\測試.xls" Rs.Open "Select * From [Sheet1$]" Rs.Save "D:\測試.xml",adPersistXML Rs.CLose Cn.close
ActiveWorkbook.SaveAs Filename:="c:\a.xml", FileFormat:=xlXMLSpreadsheet
End Sub
再
dim excelApp as excel.application
set excelApp= new excel.application
excelApp.open fileName这时候
activeWorkBook 就可以用了
activeWorkBook指的是 当前打开的excel文件!
Dim Cn as ADODB.Connection
Dim Rs as ADODB.RecordSetSet Cn=new adodb.connection
cn.open "Driver={MicroSoft Excel Driver (*.xls)};DBQ=D:\測試.xls"
Rs.Open "Select * From [Sheet1$]"
Rs.Save "D:\測試.xml",adPersistXML
Rs.CLose
Cn.close