Getopenfile

  • Thread starter Thread starter jln via OfficeKB.com
  • Start date Start date
J

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.
 
Use ChDrive and ChDir to change the current drive and folder. Then show the
file open dialog.
 
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")
 
Back
Top