| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Directory for GetOpenFileName
Excel 2003. I am using
FName = Application.GetOpenFilename("Text Files (*.txt), *.txt", , "Select ACH to select a file to process. I want this dialog to open into a specific folder. Right now it opens into my "My Documents" folder. I have tried: Application.DefaultFilePath = "\\hqserver\shared\Finance\Payroll ACH Files" and Application.DefaultFilePath = "H:\Finance\Payroll ACH Files" but neither seems to change the folder the GetOpenFilename looks in. How may I accomplish what I am trying to accomplish? Thanks and God bless. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Directory "Locked" when selecting multiple files using GetOpenFilename | Excel Programming | |||
| How to assign directory for GetOpenFilename method | Excel Programming | |||
| specify an input directory with GetOpenFilename | Excel Programming | |||
| GetOpenFilename w/default starting directory | Excel Programming | |||
| Setting default directory prior to GetOpenFilename | Excel Programming | |||
Threaded Mode
