Ken Hudson
New Member
- Joined
- Sep 10, 2007
- Messages
- 46
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?
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?