Here are some file paths I have:
H:AccountingBudget 2000Sales
Department expenses
H:AccountingBudget 2001 Sales
Department expenses
H:AccountingBudget 2002 Sales
Department expenses
H:AccountingBudget 2003 Sales
Department expenses
The workbooks “Sales” and “Department expenses” in each year are linked.
Each year I create a new Budget year and copy the previous years files.
The problem I am having is the links between sales and department expenses refer to the previous years files. For example the 2003 links in sales would read H:AccountingBudget 2002’[Department expenses]….
This is easy enough to fix with a search and replace. The real pain is the macros I have attached to my custom toolbars they refer to the previous year and I actually have to edit each button I have made.
Is there a simply way to make Excel look in the current file path automatically when a group of related workbooks are copied?
Any ideas would be appreciated.
This message was edited by Jook on 2002-04-12 12:50
H:AccountingBudget 2000Sales
Department expenses
H:AccountingBudget 2001 Sales
Department expenses
H:AccountingBudget 2002 Sales
Department expenses
H:AccountingBudget 2003 Sales
Department expenses
The workbooks “Sales” and “Department expenses” in each year are linked.
Each year I create a new Budget year and copy the previous years files.
The problem I am having is the links between sales and department expenses refer to the previous years files. For example the 2003 links in sales would read H:AccountingBudget 2002’[Department expenses]….
This is easy enough to fix with a search and replace. The real pain is the macros I have attached to my custom toolbars they refer to the previous year and I actually have to edit each button I have made.
Is there a simply way to make Excel look in the current file path automatically when a group of related workbooks are copied?
Any ideas would be appreciated.
This message was edited by Jook on 2002-04-12 12:50