| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook name in VBA doesn't match filename.xls
I have a workbook named ABC.xls, in that workbook are several macros that
reference the currently named workbook ... ABC.xls. Now, my users rename the workbook to 123.xls. When they go to run the macro in the newly named 123.xls workbook the macro fails because there are references to the old workbook name of ABC.xls. Is there a way to avoid this .. one note, having the user NOT rename the workbook is not an option. Is there a way to use a variable to reference the workbook no matter what it is named, pehaps ? Thanks in advance, Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving XLS workbook with set filename | Excel Discussion (Misc queries) | |||
| link to other workbook with changing filename | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| Filename in footer automatically in new workbook. | Excel Discussion (Misc queries) | |||
| How do I remove multiple windows of 1 workbook (filename.xls:2,:3 | Excel Discussion (Misc queries) | |||
Threaded Mode
