How do I use VC++6.0 to protect a excel file to readonly

G

gowinder

I use VC++6.0 to create a temp excel file, and I don't want other use
to modify it, I use _Workbook.ChangeFileAccess to set readonly, but i
cannot help, a exception throw out, the message is "cannot fin
member", when I invoke ChageFileAccess function, the code is lik
this:

COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,
VT_ERROR),vtTrue((short)TRUE),vtFalse((short)FALSE);
_Application *ExcelApp = new _Application;

ExcelApp->CreateDispatch("excel.application");



//ÉèÖÃΪÏÔʾ
ExcelApp->SetVisible(TRUE);
//µÃµ½WorkBooks
Workbooks ExcelBook=ExcelApp->GetWorkbooks();



Sheets ExcelSheet=ExcelBook.Add(vtOptional);
_Workbook workBook;
_Worksheet workSheet;
Range range;
workBook.AttachDispatch(ExcelApp->GetApplication());

ExcelSheet=workBook.GetSheets();

////////////////////////////////////////////
workSheet=ExcelSheet.GetItem(COleVariant((short)1));
workSheet.Activate();

can anyone help me? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top