OS: MS XP
Excel: 2002

I have (2) two workbooks in the same directory. One workbook opens the other.
The (2) two workbooks will always be together in the same directory but on
occasions the directory will change.

Is there a way in a macro to always use the path of workbook €œA€� to open
workbook €œB€�?

Thanks in advance.


--
Richard

Maybe this will help
Sub test()
MsgBox ThisWorkbook.Path & "\" & "workbook2name" & ".xls"
End Sub

"Richard" wrote:

OS: MS XP
Excel: 2002

I have (2) two workbooks in the same directory. One workbook opens the other.
The (2) two workbooks will always be together in the same directory but on
occasions the directory will change.

Is there a way in a macro to always use the path of workbook €œA€� to open
workbook €œB€�?

Thanks in advance.


--
Richard

Richard,

Try something like

Dim PathA As String
PathA = Workbooks("BookA.xls").Path
Workbooks.Open Filename:=PathA & "\" & "BookB.xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Richard" wrote in message
...
OS: MS XP
Excel: 2002

I have (2) two workbooks in the same directory. One workbook opens the
other.
The (2) two workbooks will always be together in the same directory but on
occasions the directory will change.

Is there a way in a macro to always use the path of workbook €œA€� to open
workbook €œB€�?

Thanks in advance.


--
Richard