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!
