Using vba to open file in same folder as current workbook

[misrael]

I'm needing to constantly save my files in new folders (for each job I do) and I'm trying to open a file, let's call it "test.xls" from whichever job file I'm in. I only know how to input the exact path, but that won't work for me.
I've read a little about "currentproject.path", but can't get it to work. Any help is appreciated.

 

[Tom Urtis]

The keywords you want for object and property are

activeworkbook.path

 

[misrael]

You're a life saver. Thanks.