Thread
:
Create a new file, name it and overwrite an existing name without confimation
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Create a new file, name it and overwrite an existing name without confimation
Have you tried
application.displayalerts=false
do it
application.displayalerts=true
--
Don Guillett
SalesAid Software
"Rob" wrote in message
. ..
Hell FellowNewsgroupreaders,
basically the title syas it all.
I have to recreate some 200 files and update them on a regular basis.
Don't ask me why but opening and editing the existing file is not an
option. I create a new file, save it and overwrite the existing (closed)
file. Even in a macro I still have to confirm this overwrite. How do I
avoid that? Can't find it in the literature and on some helpful sites.
Rob
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett