View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Bloom Greg Bloom is offline
external usenet poster
 
Posts: 10
Default Applicaition Default File Path

In Excel - my 'Default File Location' is C:\Data

In my VBA Code:
I set the Application.DefaultFilePath = "C:\OE"
I then set File_Name = Application.GetOpenFilename(filefilter:=Filt,
FilterIndex:=FilterIndex, Title:=Title)

But it always goes to the last data path that was used to open a file in
Excel. I can not get the new default path (C:\OE) to work in the the
GetOpenFileName.

Thanks
Greg Bloom