Capturing current folder path

When clicking on the OPEN dialog box, .xls displays the current "folder
path". How do I programatically capture this current path.

My objective is following:

programatically I will be changing the folder from where to pick up files
and save files. However, when I quit the macro I would like to reset the
folder to the original setting before I started the macro. Hence I would
like to capture the current folder space so that I can revert back to it at
the end.

Many thanks in anticipation of your reply.

Check out CurDir.

NickHK

"DKS" <[email protected]> wrote in message
news:[email protected]...
> When clicking on the OPEN dialog box, .xls displays the current "folder
> path". How do I programatically capture this current path.
>
> My objective is following:
>
> programatically I will be changing the folder from where to pick up files
> and save files. However, when I quit the macro I would like to reset the
> folder to the original setting before I started the macro. Hence I would
> like to capture the current folder space so that I can revert back to it
at
> the end.
>
> Many thanks in anticipation of your reply.

Thanks.

"NickHK" wrote:

> Check out CurDir.
>
> NickHK
>
> "DKS" <[email protected]> wrote in message
> news:[email protected]...
> > When clicking on the OPEN dialog box, .xls displays the current "folder
> > path". How do I programatically capture this current path.
> >
> > My objective is following:
> >
> > programatically I will be changing the folder from where to pick up files
> > and save files. However, when I quit the macro I would like to reset the
> > folder to the original setting before I started the macro. Hence I would
> > like to capture the current folder space so that I can revert back to it
> at
> > the end.
> >
> > Many thanks in anticipation of your reply.
>
>
>