使用Automation时,调用excel的SaveAs,能否指定存盘格式?
.h中
Variant myExcel;
.cpp中,
void __fastcall TForm1::FormCreate(TObject *Sender)
{
myExcel = Variant::CreateObject("excel.application");
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button1Click(TObject *Sender)
{
Variant MyWorkBook=myExcel.OlePropertyGet("workbooks");
Procedure Open("Open");
if (od->Execute())
{
//MyWorkBook.Exec(Open <<od->FileName);
MyWorkBook.Exec(Open <<od->FileName);
}
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button2Click(TObject *Sender)
{
if (od->Execute())
{
Procedure SaveAs("SaveAs");
Variant ActiveWorkBook=myExcel.OlePropertyGet("ActiveWorkbook");
ActiveWorkBook.Exec(SaveAs <<od->FileName);
}
}
//---------------------------------------------------------------------------
能否在最后的
ActiveWorkBook.Exec(SaveAs <<od->FileName);
指定他存为"Microsoft Excel 5.0/95 工作簿"?
怎么写?谢谢