Saving an Excel worksheet without getting the confirmation box
 

I am attempting to update data into a spreadsheet, which I
have declared as an object using the CreateObject()
function. The problem is that I want to write a new row of
data then save, using the existing file name i.e.
overwrite the file, but don't want to confirm this each
time.

Saving an Excel worksheet without getting the confirmation box
 

Mike, try this

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Mike" wrote in message
...
I am attempting to update data into a spreadsheet, which I
have declared as an object using the CreateObject()
function. The problem is that I want to write a new row of
data then save, using the existing file name i.e.
overwrite the file, but don't want to confirm this each
time.