It's been a long time...

[Mr Nick]

It's been a long time since I worked with Excel and alot of my knowledge has been pushed aside with other more recent stuff. I have now just started looking at some old Excel stuff and have realised that one of the basics I have forgotten is how to reference a workbook in relative terms.

I want to open a sheet and when it opens, it opens a further sheet automatically ie Workbooks.Open FileName:="C:\Branches.xls" but without specifying where the file is stored as it will always be in the same directory as the first sheet opened but could be on any drive in any subdirectory.

A quick nudge in the right direction would be much appreciated.

 

[Juan Pablo González]

It's been a long time since I worked with Excel and alot of my knowledge has been pushed aside with other more recent stuff. I have now just started looking at some old Excel stuff and have realised that one of the basics I have forgotten is how to reference a workbook in relative terms.

I want to open a sheet and when it opens, it opens a further sheet automatically ie Workbooks.Open FileName:="C:\Branches.xls" but without specifying where the file is stored as it will always be in the same directory as the first sheet opened but could be on any drive in any subdirectory.

A quick nudge in the right direction would be much appreciated.

Do you need this ?

Workbooks.Open ThisWorkbook.Path & "\Branches.xls"
Sheets(1).Select

 

[Mr Nick]

I most certainly do.

I knew it was easy, just lost in the mists of time.

Thanks.