View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
German[_2_] German[_2_] is offline
external usenet poster
 
Posts: 5
Default Open Dialogue Box to a certain folder?????

Does anyone know how to open a dialogue box that will open to a
specific folder of my choosing?? I am able to open the dialogue box
but it defaults to the last folder that was used.

The code I am using looks like this:

'Filt = "All Files (*.*),*.*"
'Title = "Import Routine"
'FileName = Application.GetOpenFilename(Filt, 5, Title, True)

Thanks in Advance

G-.