Folder Search Location Using VB

[Ken Hudson]

I have several macros that use code like this:

strFileOpenName = Application.GetOpenFilename("Text Files (*.txt),*.txt", 1, "Find F850 Text File", , False)

When invoked the user is prompted to open a file in the path that has been set up in the "File Save" option. I don't want to change the default file save path but I do want to be able to set a different search location when this line of code runs. The dafualt file open location may be "C:\Excel\Files." In this macro I want the user to see files in "C:\Macro\Files." How do I change/add to this code to accompish that?

 

[Juan Pablo González]

You can use ChDir to change the current active directory, which will be used when the GetOpenFileName is executed.

 

[Ken Hudson]

Gracias Amigo!
Don't you like one or two easy ones now and then?