Opening workbook in same directory

  • Thread starter Thread starter Andyjim
  • Start date Start date
A

Andyjim

Is the only way to open another workbook programatically from the workbook
that is currently open to use the Workbooks.Open filename:= command to supply
the path and the workbook name? Is there any way you can open another
workbook that resides in the same directory without supply the path?

Thanks much.

Andy
 
You don't need to hard code the path. Use something like:

fname = "something.xls"
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & fname
 
Wow.. Good answer. Thanks

Gary''s Student said:
You don't need to hard code the path. Use something like:

fname = "something.xls"
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & fname
Click to expand...
 
You must log in or register to reply here.

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

Excel Protection 2
code to open another workbook 3
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Open four Wbooks, copy four columns from each to Master Wbook 16
Import multiple workbooks to current workbook in specified row number 0
Problem with file path to sharepoint 0
Save As and new workbook new name used in existing code 8
Function or formula to show currently active workbook name in cell 1

Back
Top