Home » Developer & Programmer » Forms » Automatically save exel file
Automatically save exel file [message #83659] Wed, 19 November 2003 13:08 Go to next message
Nina Villegas
Messages: 13
Registered: November 2003
Junior Member
I want to automatically save and overwrite the old version of my excel file whenever I run this line:

ole2.invoke(application, 'saveAs', args);

But it always asks me if I want to overwrite and replace my existing file. How can I get rid of this message so that it will automatically save my new excel file without any questions?
Re: Automatically save exel file [message #83675 is a reply to message #83659] Mon, 24 November 2003 07:45 Go to previous messageGo to next message
Messages: 324
Registered: January 2003
Senior Member
i know that it is possible
i got no examples for you but you should know how excel works.
there are objects and methods.
there is one method wich shows the save-dialogbox
that property should be set to not show the save-dialogbox.
run excel application and pres ALT+F11 for the visual basic editor and check out the excel properties.
Re: Automatically save exel file [message #83726 is a reply to message #83659] Wed, 03 December 2003 17:41 Go to previous message
Lars O Sjöström
Messages: 25
Registered: May 1999
Junior Member
Have you tried to replace 'saveAs' with 'Save' or 'save'? Since menu choice "Save As" in Word/Excel or what have you always asks.
Previous Topic: how to create a module component(form) in designer
Next Topic: Forms 4.5/Oracle 9i
Goto Forum:

Current Time: Thu May 23 03:39:51 CDT 2024