Current Directory

[MikeH2]

How can I determine the current directory I am "pointing to"? Not the
directory that the current file came from but if I were to select File>Open,
what directory would come up. I need to save that location and later come
back to it.

 

[FSt1]

hi
sub finddir()
msgbox curdir
end sub

regards
FSt1

 

[FSt1]

after thought
sub finddir()
msgbox curdir
range("a1").value = curdir
dim d as string
d = curdir
msgbox d
range("A2").value = d
end sub