MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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