Macro to open Workbook in default path.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Maybe this will help
Sub test()
MsgBox ThisWorkbook.Path & "\" & "workbook2name" & ".xls"
End Sub
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Merge Multiple workbook sheets into one workbook 0
Macro to push data to another workbook 0
I hate paths! 2
Disable Macro Alert 2
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Workbook does not open by default in Excel 2007 2
Macro to open seperate workbook 3

Back
Top