Open file from same path

  • Thread starter Thread starter Kashyap
  • Start date Start date
K

Kashyap

How to open another excel file from the same path of this file without giving
the full path using macros?
 
Kashya, you may use CHDrive and CHDir as below

ChDrive "c"
ChDir "c:\temp\"
Workbooks.Open "1.xls"

If this post helps click Yes
 
How to open another excel file from the same path of this file without giving
the full path using macros?
Click to expand...

Workbooks.Open ActiveWorkbook.Path & "\OtherFileName.xls"
 

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

Problem with file path to sharepoint 0
Path and File 1
File Path 2
Path and File 1
Problem opening an Excel file from code 2
Looping Open and Save as CSV 9
Open file from path in cell and open from current file path 0
How to read Excel Array to vb.net Arrays? 20

Back
Top