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.

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.