View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Valenti Ken Valenti is offline
external usenet poster
 
Posts: 40
Default Specify Start Location for GetOpenFileName box

This seems to works too

const TheFolderPath = "\\Anywhere"
Application.GetOpenFilename(filefilter:="Excel Files (*.xls)," &
TheFolderPath & "\*.xls")

"WCR" wrote:

Can you specify the start location for the getopenfilename dialog box?

Dim f As String
f = Excel.Application.GetOpenFilename("LIS Files (*.lis), *.lis")

I would like to start the search in a specific location, instead of "My
Documents". Couldn't find any info on this topic yet.

Thanks!