Default Path for File Open

  • Thread starter Thread starter gilgil
  • Start date Start date
G

gilgil

I want the DialogBox open on the folder E:\Transit

Application.DefaultFilePath = "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

Why this code don't works?
Thank!
 
ChDrive "E:\Transit"
ChDir "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Directory for GetOpenFileName 4
how to dynamically import a text file 1
Excel VBA. Setting the default path for GetOpenFileName 2
GetOpenFilaName 3
Open Text based on creation date 4
Code for Select a file and save it in a different location 2
Open Folder Help required 2
Open a folder 1

Back
Top