| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where to put the sub-programm, GetOpenFile | Excel Programming | |||
Hybrid Mode
