Getopenfile
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200712/1

Getopenfile
 

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

--
Jim
"jln via OfficeKB.com" <u25956@uwe wrote in message
news:7d2b6b658db9f@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200712/1

Getopenfile
 

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

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200712/1

Getopenfile
 

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

--
Jim
"jln via OfficeKB.com" <u25956@uwe wrote in message
news:7d2cb7a90e2a6@uwe...
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 wrote:
Use ChDrive and ChDir to change the current drive and folder. Then show
the
file open dialog.

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200712/1