K Kashyap May 29, 2009 #1 How to open another excel file from the same path of this file without giving the full path using macros?
How to open another excel file from the same path of this file without giving the full path using macros?
J Jacob Skaria May 29, 2009 #2 Kashya, you may use CHDrive and CHDir as below ChDrive "c" ChDir "c:\temp\" Workbooks.Open "1.xls" If this post helps click Yes
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 May 29, 2009 #3 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"
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"
