ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I use VC++6.0 to protect a excel file to readonly (https://www.excelbanter.com/excel-programming/340672-how-do-i-use-vc-6-0-protect-excel-file-readonly.html)

gowinder

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

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

--
gowinderPosted via http://www.officehelp.in - <a href="http://www.officehelp.in">Microsoft Office Software</a&gt


gowinder[_2_]

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

Please help me

--
gowinderPosted via http://www.officehelp.in - <a href="http://www.officehelp.in">Microsoft Office Software</a&gt


gowinder[_3_]

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

can anyone help me please

--
gowinderPosted from - http://www.officehelp.i



All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com