Target

[Param]

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

[Daniel CHEN]

Try to use the following which opens the file in the same directory as the
active workbook:

sub foo()
dim wbk as workbook
set wbk=activeworkbook
workbooks.open Activeworkbook.Path&"\b.xls"
wbk.close
end sub

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download



"Param" <[email protected]> wrote in message
news:[email protected]...
> 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
>