Kashya, you may use CHDrive and CHDir as below

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

If this post helps click Yes
---------------
Jacob Skaria


"Kashyap" wrote:

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