How to open an Excel file with Password? [message #122345] |
Mon, 06 June 2005 01:26 |
deepaknalkur
Messages: 1 Registered: June 2005 Location: india
|
Junior Member |
|
|
We are using the following code to open an excel file. This code opens a excel file without password. We require to open an excel file with password.
The Code in the Form is :-
DECLARE
app OLE2.OBJ_TYPE;
wrkbks OLE2.OBJ_TYPE;
wrkbk OLE2.OBJ_TYPE;
BEGIN
app := OLE2.CREATE_OBJ('Excel.Application');
wrkbks := OLE2.GET_OBJ_PROPERTY(app,'Workbooks');
args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args,floc);
wrkbk := OLE2.INVOKE_OBJ(wrkbks, 'Open', args);
.
.
.
.
OLE2.INVOKE(app,'Quit');
OLE2.RELEASE_OBJ(app);
END;
|
|
|