Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do set excel up to auto replace a file?
i need to set my excel sheets up to beable to replace itsself without a box
prompting me can someone plzzzzzzzzz help? for example my sheet is a game sheet.when I play my first game I hit a certain button and it creates a certain folder on my hard drive this folder is for certain excel sheets but when i go to do another round on the same excel sheet its suppose to auto replace the first round in that folder.but instead when I hit the button a box pops up asking if i wanna replace the first one. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do set excel up to auto replace a file?
Jenn, maybe
Application.DisplayAlerts = False 'Your Code Application.DisplayAlerts = True -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jenn" wrote in message ... i need to set my excel sheets up to beable to replace itsself without a box prompting me can someone plzzzzzzzzz help? for example my sheet is a game sheet.when I play my first game I hit a certain button and it creates a certain folder on my hard drive this folder is for certain excel sheets but when i go to do another round on the same excel sheet its suppose to auto replace the first round in that folder.but instead when I hit the button a box pops up asking if i wanna replace the first one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
How to auto arrange the worksheet in a excel 2002 file? | Excel Worksheet Functions |