how to change absolute path to relative path
 

I have two different workbooks. Some cells in workbook 1 are using cells
from workbook 2. These cells use the absolute path of workbook 2.
When I copy these files to another computer I have to create the exact
same path otherwise it will not work. Can I make relative path in my
workbooks so it will work on any computer ?

Henry


--
hwijgerse
------------------------------------------------------------------------
hwijgerse's Profile: http://www.excelforum.com/member.php...o&userid=29083
View this thread: http://www.excelforum.com/showthread...hreadid=488091