Autosave macro
Posted by Edo on September 16, 2000 7:34 AM
I'm trying to write a macro that will save a specific worksheet as csv file every 5 min to the same path.
but after the first time I get a message that tell me that "file with this name is already....."
and I have to click yes to complete the save process
Can I bypass this message?
Posted by Ivan Moala on September 17, 0100 12:04 AM
Use Application.Displayalerts=False
Look up online help for this.
Note: excel97 you will have to reset this to
True after.
Ivan
