Opening Files

[toocold]

Good morning all!

I am working on something that will allow a user to run different scerios and view the results. Once they have something that they want to explore further, they can export the results to a new workbook. If they want to go back to an option that was previously exported, there is a button on one of the user forms that will call the open feature and let the user select which which files to open.

My issue is that the Application.GetOpenFilename feature seems to default to the last place that the user saved any excel file. Even if it is a different from where this one is located. Is there a way to control this? I want it to default to wherever this workbook is saved and let the user look there first.

Thanks in advance,
dw

[Tom Ogilvy]

spath = curdir
Chdrive Thisworkbook.path
chdir Thisworkbook.Path
fname = Application.GetOpenFilename()

.. . .
chdrive spath
chdir = spath


--
Regards,
Tom Ogilvy


"toocold" wrote:

>
> Good morning all!
>
> I am working on something that will allow a user to run different
> scerios and view the results. Once they have something that they want
> to explore further, they can export the results to a new workbook. If
> they want to go back to an option that was previously exported, there
> is a button on one of the user forms that will call the open feature
> and let the user select which which files to open.
>
> My issue is that the Application.GetOpenFilename feature seems to
> default to the last place that the user saved any excel file. Even if
> it is a different from where this one is located. Is there a way to
> control this? I want it to default to wherever this workbook is saved
> and let the user look there first.
>
> Thanks in advance,
> dw
>
>
> --
> toocold
> ------------------------------------------------------------------------
> toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
> View this thread: http://www.excelforum.com/showthread...hreadid=566090
>
>

[toocold]

Thanks Tom,

Nice and simple!
dw