Thread: Opening Files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
toocold[_30_] toocold[_30_] is offline
external usenet poster
 
Posts: 1
Default Opening Files


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