| Automatically save exel file [message #83659] |
Wed, 19 November 2003 13:08  |
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  |
magnetic
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
