how to change absolute path to relative path

H

hwijgerse

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
 
Top