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.

hi
sub finddir()
msgbox curdir
end sub

regards
FSt1

"MikeH2" wrote:

> 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.

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

"FSt1" wrote:

> hi
> sub finddir()
> msgbox curdir
> end sub
>
> regards
> FSt1
>
> "MikeH2" wrote:
>
> > 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.