hi, I have macro command that link file A to file B
Q: anyway to write this command without mention the directory e.g
"C:\temp\b.xls"
because all the file within one folder (e.g temp). I counter problem when
copy this folder to another PC, where the location are not same. Like copy to
my document and run it.

sub foo()
dim wbk as workbook
set wbk=activeworkbook
workbooks.open "C:\temp\b.xls"
wbk.close
end sub