Open file from a designated path

[u742884]

I am trying to write code that prompts users to open files from a specific path. I am using GetOpenFilename, which works great except that the File-Open dialog box starts with your default path (or the last one you opened something from). I want it start in a designated path.

Thanks in advance for your help!

 

[Von Pookie]

At the moment I can't remember if it actually works, but it's worth a shot: you can try changing the directory to what you want before you call the GetOpenFileName:

ChDir "C:\This Folder\"

You may also need to change the drive if you're looking elsewhere. You can use the ChDrive statement for that. For example: ChDrive "H:"

 

[u742884]

Nope. Tried that.

 

[jag108]

I have tested this and works for me.

ChDrive "c:\" " I.E any network or local drive first
ChDir "C:\folder path" ' Then the path seems to work for me.

Then I use

Application.GetOpenFilename(sFilter, , sTitle, , False)

 

[u742884]

That worked afterall. I think in my prior attempts, I left off the "\" in the ChDrive statement and that statement would error out. Since I wasn't sure if it was a real command since I had guessed on based on the ChDir command, I took it out and just tried with ChDir MyPath.

Together it worked.
ChDrive "Q:\"
ChDir MyPath

Thank you! That was driving me crazy.