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


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


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