Open file from same path

K

Kashyap

How to open another excel file from the same path of this file without giving
the full path using macros?
 
J

Jacob Skaria

Kashya, you may use CHDrive and CHDir as below

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

If this post helps click Yes
 
D

Dick Kusleika

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"
 
Top