ExcelBanter - Open file from same path

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open file from same path (https://www.excelbanter.com/excel-programming/429132-open-file-same-path.html)

Kashyap

Open file from same path

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

Jacob Skaria

Open file from same path

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?

Dick Kusleika[_4_]

Open file from same path

On Fri, 29 May 2009 07:21:01 -0700, Kashyap
wrote:

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

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

--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com

All times are GMT +1. The time now is 12:13 PM.