Getopenfile

[jln via OfficeKB.com]

Right now i have it so the user can browser for the folder they want then
select a file. I want to change this to going to

Q:\FTP\as400\exports\production\

then select the folder and file.

 

[Jim Rech]

Use ChDrive and ChDir to change the current drive and folder. Then show the
file open dialog.

 

[jln via OfficeKB.com]

IUS this what you mean?


ChDir ("Q:\FTP\as400\exports\production\inv" & _
Inv & "\")
myFileName = Application. _
GetOpenFilename(filefilter:="csv Files, *.CSV", _
Title:="Pick a File (Select your MAR")

 

[Jim Rech]

You have to use ChDrive to (unless you're certain Q: is already active).