providing a directory for getopenfilename method 1

[smooveb]

Hi everyone,

I'm using the GetOpenFilename method as shown below:

Filename = Application.GetOpenFilename(filefilter:=filt, Title:=Title)

What I'm wondering is this: how can i provide a default directory on my C: for this to occur in? I'd like to avoid the user needing to browse to the same directory each time (from My Documents, where it seems to be opening now).

Thanks!
Barrett

 

[PHV]

Simply use the ChDir instruction before.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[smooveb]

thanks so much!

B