Re: 'Save as' operation using winapi in oracle forms
From: Marino Ljubic <mljubic_at_globalnet.hr>
Date: Fri, 27 Jun 2003 16:22:45 +0200
Message-ID: <bdhk2n$c22d$1_at_as201.hinet.hr>
Date: Fri, 27 Jun 2003 16:22:45 +0200
Message-ID: <bdhk2n$c22d$1_at_as201.hinet.hr>
"Manikandan" <member12054_at_dbforums.com> wrote in message
news:3037289.1056461734_at_dbforums.com...
>
> Hi,
> I have to convert('Save as') .xls file to .csv file.
> Here i have to do it during runtime without the user intervention.
> Is there any api call to perform this?.If not is there any other way
> of doing so?
Yes, through the OLE2 package you can perform Excel VBA methods. In this case, you must use SaveAs method of Workbook object. The first argument is FileName, and the second is FileFormat for which you must pass 6 (numeric value), equivalent to xlCSV (Excel constant). Received on Fri Jun 27 2003 - 16:22:45 CEST