how to open the directory window and then stop ?

[jokkebal]

Hi,
I want my macro to perform some actions, and the last one is to open a specific folder in which I then can choose a file to open. I don't want the macro to open the file, because I want to choose the file that the macro is going to open.

How can I guide the macro to open the correct file subfolder ?

This is what I have (and works) :


vFile = Application.GetOpenFilename("Excel Files (*.xl*)," & "*.xl*", 1, "Select Excel File", "Open", False)

(here I select the file)

Workbooks.Open vFile



So, what is missing, is the instruction to go and look into the correct folder. To my surprise, the following line is not working :

ChDir "\\fs01\Data\Breemes\CSS2\Flows\Accordion Files\A In Process"

Thanks and best wishes to everyone !
Josse.

 

[svendiamond]

ChDir works just fine for me and should for you, too. Maybe there is an issue with your directory? Try a different directory and see if it works... also you're putting the ChDir command before trying to open the file, right?

ChDir "\\fs01\Data\Breemes\CSS2\Flows\Accordion Files\A In Process"
vFile = Application.GetOpenFilename("Excel Files (*.xl*)," & "*.xl*", 1, "Select Excel File", "Open", False)
Workbooks.Open vFile

 

[jokkebal]

Hi Sven,
Thanks for your reply. It works !
"Maybe there is an issue with your directory" : That was it. I recorded the whole action in a macro and saw a difference in the way the macro wrote the directory.
Apparently, there are two (or more) ways to describe a path, where one is not wrong (no error message or stopping macro) but not good enough for the next step...

Best regards,
Josse.

 

[svendiamond]

Was it the double backslashes at the beginning?

 

[jokkebal]

Yes and no : replaced "\\fs01\Data\" with "K:"
The funny thing is that the first didn't seem to be wrong; I didn't receive any error message...
Anyhow, solved !!

 

[svendiamond]

Awesome. Merry Christmas lol