Link to home
Start Free TrialLog in
Avatar of Stephen Byrom
Stephen ByromFlag for Ireland

asked on

Changing name of Workbooks

Hi,
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.
ASKER CERTIFIED SOLUTION
Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Stephen Byrom

ASKER

Brilliant !!!
You come to my rescue yet again.
Always a pleasure to help

Chris