Macro to paste current file path into a cell?

[tonywatsonhelp]

Hi Everyone,
I have a cell called file path that i use in my document,
i'd like a macro that can fill cell G11 with the current file path
but posted as i would need it to open a document (if theres any difference?)

so i other words into cell G11 goes the current documents file path excluding its name etc (so just to the folder its in)

hope thats clear, please help if you can
Thanks
Tony

 

[Fluff]

How about

   Range("G11").Hyperlinks.Add Range("G11"), ActiveWorkbook.Path, , , "Path"

 

[mohadin]

Range("G11") = ThisWorkbook.Path

 

[tonywatsonhelp]

Thanks Fluff,
thanks mohadin,
I'll give both of these a try.
Tony

 

[Fluff]