File path problems

[Jook]

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 ]

[smozgur]

if file is "c:windowsdesktopbook1.xls" then

thisworkbook.Path = "c:windowsdesktop"

You can use thisworkbook.Path value in code.