Relative address to open workbook

[brites]

Hi folks,
Im writing a Macro that opens another workbook. Both workbooks are in the same folder, always. But the folder is always changing. Can I use relative address reference on the macro instead of qriting the whole address?

Thx!

 

[njimack]

Use:
ThisWorkbook.Path

 

[Jonmo1]

How about

ThisWorkbook.Path

 

[DonkeyOte]

not required...

 

[Norie]

Can you not use the path of the workbook the code is in to open the other workbook?

Set wbThis = ThisWorkbook ' create reference to workbook code is in
 
Set wbOther = Workbooks.Open (ThisWorkbook.Path & "\OtherWorkbookName.xls")

 

[brites]

thisworkbook.path !
simple and perfect!

Thx again!