How to keep the orignial path?

E

Eric

Does anyone have any suggestions on how to fix the path under different
directory?
This file sheet.xls is saved under following the paths
E:\Homework\class1\
E:\Homework\class2\
E:\Homework\class3\

Within the E:\Homework\class1\summary.xls - Temp sheet - cell A1, there is
a value retrieved from 'E:\Homework\class1\[sheet.xls]D'!$H$2.

When I copy this summary.xls file into following directory
E:\Homework\class2\

Under directory E:\Homework\class2\, the path E:\Homework\class1\summary.xls
- Temp sheet - cell A1 change into
'E:\Homework\class2\[sheet.xls]D'!$H$2, but I would like to keep the
original path
E:\Homework\class1\summary.xls - Temp sheet - cell A1.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric
 
J

jaf

Hi Eric,
Not clear to me.
Looks like your linking to workbooks that are named the same but in different folders.
Excel won't allow open workbooks with the same name regardless of the path.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top