EXCEL Question... probably simple 1

[webwriter]

Hi.
I am creating/saving an excel spreadsheet from a VB program. Everytime a row is added to my spreadsheet a popup message on my web page appears asking me if i want to override the current excel spreadsheet. is there a way in excel to suppress this message so that i do not get this popup message.. it would be a nuisance to my user to continually respond to this message..

thanks for any help..

webwriter..

 

[Rjc8513]

Try:

Application.DisplayAlerts=False

that disables all Excel warning messages and resets itself to "True" when the procedure is completed.

Richard...

 

[webwriter]

Richard,

Thanks... That was *exactly* what i needed. I inserted the code and it worked like a charm..

Many, many thanks..

webwriter..