OraFAQ Forum: Forms » Export Data From Excel and save on an existing excel file

Home » Developer & Programmer » Forms » Export Data From Excel and save on an existing excel file (Developer Forms, 6i, Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Data From Excel and save on an existing excel file [message #611328]

Tue, 01 April 2014 07:18

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Hi Guys,

I have successfully created a mechanism in my forms that can export my data from Oracle to an Excel file.

But the problem is that I want to save this excel file on an already existing file. Basically I want to over right the excel file name if it already exists.

I am using OLE2 package.

Report message to a moderator

Re: Export Data From Excel and save on an existing excel file [message #611354 is a reply to message #611328]

Tue, 01 April 2014 14:54

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What happens when you do it? Does Windows complain (such as "do you want to ...") or does Forms fail (with which error, if so), or ...?

Report message to a moderator

Re: Export Data From Excel and save on an existing excel file [message #611370 is a reply to message #611354]

Wed, 02 April 2014 01:05

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Yes it is showing following Excel save alert:

Windows Alert Title = Miscroft Excel

Windows Alert Message = A file named 'C:\My_Excel_Data.xls' already exists in this location. Do you want to replace it?

I don't want Windows to show me this alert. I want to overwrite this file on the existing file.

Report message to a moderator

Re: Export Data From Excel and save on an existing excel file [message #611394 is a reply to message #611370]

Wed, 02 April 2014 02:50

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Then first DELETE file C:\My_Excel_Data.xls (use HOST built-in which calls DEL operating system command). If it exists, it will be deleted. If not, nothing will happen.

Report message to a moderator

Re: Export Data From Excel and save on an existing excel file [message #611402 is a reply to message #611394]

Wed, 02 April 2014 04:20

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear Friend LittleFoot,

Thanks for your quick reply. Its been along time.

Is there any other way rather then issuing the Host delete OS command. I mean is there any way using OLE2 can save a file without asking to file already exists.

And if I use the Host delete Os command then don't you think that it will also confirm before deleting the existing Excel file.

Report message to a moderator