Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new file, name it and overwrite an existing name without confimation
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new file, name it and overwrite an existing name without confimation
Don,
sometimes you need a ousider to get rid of a temporary blackout! In ALL my macro's I enable displayalerts while creating and testing. I simply add a public const boolian that says i'm testing or not. Sure enough disabling displayalerts does the trick. Thanks! Rob "Don Guillett" schreef in bericht ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODBC Overwrite existing cells | Excel Discussion (Misc queries) | |||
accidentally click YES to overwrite an existing file | Excel Discussion (Misc queries) | |||
Overwrite existing file without prompt | Excel Programming | |||
Overwrite existing file without prompt | Excel Programming | |||
Using SaveAs Statement to overwrite existing File | Excel Programming |