我用下面的这段脚本写变量值到EXCEL中,怎么弹出这样的对话框“当前位置发现已经存在名为"d:xxx.xls"的文件,你希望将该文件替换掉吗”,这个脚本的哪个地方需要修改一下?先谢谢了!
#pragma code ("kernel32.dll")
VOID GetLocalTime(LPSYSTEMTIME lpSystemTime);
#pragma code ()
static int i=1;
char FileName[20] = " ";
SYSTEMTIME sysTime;
__object* pExcel = NULL;
GetLocalTime(&sysTime);
sprintf(FileName,"d:\\%d-%d-%d.xls",sysTime.wYear,sysTime.wMonth,sysTime.wDay);
pExcel = __object_create("Excel.Application.12");
pExcel->Visible = 0;
pExcel->Workbooks ->Open ("d:\\Book1.xls");
i++;
pExcel->WorkSheets("sheet1")->Cells(i,1)->Value=10;
pExcel->WorkSheets("sheet1")->Cells(i,2)->Value=20;
pExcel->WorkSheets("sheet1")->Cells(i,3)->Value=30;
pExcel->ActiveWorkbook->SaveAs(FileName);
pExcel->Workbooks->Close();
pExcel->Quit();
__object_delete(pExcel);