用OLE将EXCEL另存为其他格式
EXCEL中想将.xls另存为.htm,或.htm另存为.xls,录制的宏如下:
Sub Macro1()
'
' Macro1 Macro
' 宏由 MC SYSTEM 录制,时间: 2005-3-15
'
'
ActiveWorkbook.SaveAs Filename:= _
"F:\cc.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
"F:\cc.htm", FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
"F:\cc.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub
======================================================
以下代码可以“另存为”,但无法转换文件格式!
Variant vExcelApp, vWorkbook, vRange,;
vExcelApp = Variant::CreateObject("Excel.Application");
vExcelApp.OlePropertySet("Visible", false);
vExcelApp.OlePropertyGet("WorkBooks").OleProcedure("Open", "A.HTM");//A.HTM是别的.XLS转存的
vWorkbook = vExcelApp.OlePropertyGet("ActiveWorkbook");
vExcelApp.OlePropertySet("Visible",(Variant)true);
Sleep(2000);
vWorkbook.OleProcedure("SaveAs", "A.xls");//这里的A.xls还是A.HTM的文本内容
=============================================================================
我要问:用OLE的什么方法可以设置FileFormat?如同宏的:FileFormat:=xlNormal