Good morning all!

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

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

Thanks in advance,
d

--
toocol
-----------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...fo&userid=3160
View this thread: http://www.excelforum.com/showthread.php?threadid=56609

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

Thanks Tom,

Nice and simple!
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
View this thread: http://www.excelforum.com/showthread...hreadid=566090