View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Changing Directory for GetOpenFileName

Try ChDir and ChDrive

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Chaplain Doug" wrote in message
...
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