Changing name of Workbooks
Posted on 2011-02-20
There are two workbooks that people work in each week.
I have done some VBA which is attached to a button in workbook 1.
I would like to pass some information from workbook 1 to workbook 2.
I have found some good advice on here how to do that, when the workbooks have a constant name.
My problem is that each week, "the powers that be", insist on saving the updated workbooks to include the week number. So each week the name of the workbooks change.
So workbook 1 is called for example "Plant 2 Performance Wk 5 2011", and workbook 2 is "Plant 2 Scoreboard Wk 5 2011", and each week the week number is incremented by 1 manually.
I don't mind the manual saving, (a database is being developed to replace these workbooks), but I would like to be able to open the "Plant 2 Scoreboard Wk ? 2011" from the button on Plant 2 Performance Wk ? 2011" where the week numbers match.
(both workbooks are in the same folder on a file server, and "Plant 2 Performance Wk ? 2011" is always opened and updated before "Plant 2 ScoreboardWk ? 2011" is opened.
As always any help is appreciated.