How do I reference the root when opening a file

[Richynero]

Hello guys,

I have the following line of code...

Workbooks.Open FileName:="C:\Documents and Settings\richard.nero\My Documents\Chris Gray\5 regions\" & FileName, UpdateLinks:=0, Notify:=False

Now I know that the file that the macro is in is going to be the same folder of my 'fileName'. How can I just tell the VBA to open the file from the root. Do I have to find the location of the macro file and then set that to a variable. I was hoping to do something like

Workbooks.Open FileName:="\" & FileName, UpdateLinks:=0, Notify:=False

But that does not work.

Thanking you great people in advance.

 

[Richynero]

and today I learned about

Workbooks.Open FileName:=[COLOR=#0000ff]ThisWorkbook.Path [/COLOR]& FileName, UpdateLinks:=0, Notify:=False
</PRE>