| Ugent!! Help!!Help! Where to rename the Excel WorkSheet when I add new WorkSheet with OLE2 in oracle [message #77747] |
Sun, 11 November 2001 23:06  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
My Os is win2000 professional.
I use the oracle developer/2000 Form.
Question1:
From Form online help,I only can find a little parameters form ole2,where to find it more??
For example: OLE2.INVOKE_OBJ(worksheets, 'Add');
The online help didn't describe much property,such as Add,..?? Where to find more information ??
Question2:
I want to rename the Excel WorkSheet when I add new WorkSheet,how to do it with Ole2 in Form??
Question3:
When I close and release the Excel Application with Ole2,the Excel.exe still exist in the Task Memory.
How to really release it??
Form example I use is below:
OLE2.INVOKE(workbook,'Close');
OLE2.INVOKE(application, 'Quit');
OLE2.RELEASE_OBJ(workbooks);
OLE2.RELEASE_OBJ(application);
----------------------------------------------------------------------
|
|
|
|
| Re: Ugent!! Help!!Help! Where to rename the Excel WorkSheet when I add new WorkSheet with OLE2 in or [message #77756 is a reply to message #77747] |
Tue, 13 November 2001 05:11  |
Srinivas Konda
Messages: 29
Registered: October 2001
|
Junior Member |
|
|
Hope the following will help you.
args := OLE2.CREATE_ARGLIST;
-- to save as the file to some other file.
OLE2.ADD_ARG(args, :excel.file_name);
OLE2.INVOKE(worksheet, 'SaveAs', args);
-- Release the OLE objects
OLE2.DESTROY_ARGLIST(args);
OLE2.RELEASE_OBJ(cell);
OLE2.RELEASE_OBJ(worksheet);
OLE2.RELEASE_OBJ(worksheets);
OLE2.RELEASE_OBJ(workbook);
OLE2.RELEASE_OBJ(workbooks);
OLE2.RELEASE_OBJ(application);
Let me know if you need more info.
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
