Selecting folder for file output in VBA

[Controller]

Hello all!

I want to give the user the posibility of chosing the folder for the output file. Of course I am talking about navigating through folders up to getting the desired one and not puting the folder path in a message box.

The code could be:

THISSHOULDBETHEFOLDER= ??????????????
Open THISSHOULDBETHEFOLDER & "FILENAME.TXT" For Output As #1

Any idea?

Thank you!

 

[Juan Pablo González]

Controller, I just did a search using Browse Folder and chose "All Words", and got 36 results on that. Try it out.

 

[Controller]

On 2002-09-03 07:43, Juan Pablo G. wrote:
Controller, I just did a search using Browse Folder and chose "All Words", and got 36 results on that. Try it out.

Lo siento, yo soy el primero que se molesta cuando se pregunta sin mirar. Habia intentado la busqueda en Google sin exito.

No se me ocurrió buscar en el foro

Disculpas

(Only apologizing for asking without searching first...)
This message was edited by Controller on 2002-09-03 12:19