Export data to Excel sheet using Forms [message #618239] |
Wed, 09 July 2014 15:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/177954.jpg) |
thelearner
Messages: 133 Registered: April 2013 Location: INDIA
|
Senior Member |
|
|
Hi, I written this below code program units
....
Arglist := OLE2.Create_Arglist;
OLE2.Add_Arg (Arglist, 'c:\TEMP\test.xls');
OLE2.Invoke (workbook, 'Save', Arglist);
OLE2.Destroy_Arglist (Arglist);
...
While running the form it is opening new Excel sheet and showing the data.
My requirement is:
I want to save the excel file in Temp file. But it is not saving in particular location.
Please give any suggestions.
The Learner.
|
|
|
|
|
|
|
|