| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid saving over an excisting Workbook.?.?
I am not versed in VBA.
Right now I have a macro that saves 1 worksheet as a new workbook and saves as a value in cell B5. Everytime I change the value of B5 and run the macro I get a new workbook. What I want is a macro that asks... If the value in cell B5 is the same as any of the file names in the folder with the workbooks that were saved as the previous values in B5 Then give me a warning that the value in B5 has been used so that I do not accidently save over one of the saved workbooks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Data at the End of a excisting Collum | Excel Programming | |||
| How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
| How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) | |||
| How can I avoid excel saving xla combo data? | Excel Programming | |||
Threaded Mode
