Opening workbook in same directory
 

Is the only way to open another workbook programatically from the workbook
that is currently open to use the Workbooks.Open filename:= command to supply
the path and the workbook name? Is there any way you can open another
workbook that resides in the same directory without supply the path?

Thanks much.

Andy

Opening workbook in same directory
 

You don't need to hard code the path. Use something like:

fname = "something.xls"
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & fname

--
Gary''s Student - gsnu200765


"Andyjim" wrote:

Is the only way to open another workbook programatically from the workbook
that is currently open to use the Workbooks.Open filename:= command to supply
the path and the workbook name? Is there any way you can open another
workbook that resides in the same directory without supply the path?

Thanks much.

Andy

Opening workbook in same directory
 

Wow.. Good answer. Thanks

"Gary''s Student" wrote:

You don't need to hard code the path. Use something like:

fname = "something.xls"
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & fname

--
Gary''s Student - gsnu200765


"Andyjim" wrote:

Is the only way to open another workbook programatically from the workbook
that is currently open to use the Workbooks.Open filename:= command to supply
the path and the workbook name? Is there any way you can open another
workbook that resides in the same directory without supply the path?

Thanks much.

Andy