MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Prevent file OVERWRITE warning while using VBA


Posted by Bill Roberts on February 11, 2000 9:48 AM

i have a macro which finalizes by writing to the disk.

i want to BRUTE FORCE copy instead of getting the verification pop-up windows.

how do disable the warning?


Posted by Chris on February 11, 2000 10:52 AM

Bill,

Application.DisplayAlerts = False
'''Save Command Here
Application.DisplayAlerts = True

HTH,
Chris

Posted by bill roberts on February 14, 2000 8:49 AM

Kudos!