Juan,

The GetOpen method does allow you to select a folder, but not just a folder.
Is that what you mean? If so, I would have given you very similar code to
that article. Don't worry it won't break.

If you have XL2002 or later, there is a folder browser dialog.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Juan Sanchez" wrote in message
...
Bob/Andy

Thanks!
Both of your suggestions work great, exept that i need to
get a file selected at the end... It does not allow me to
select a folder. I found sort of what I'm looking for he

http://support.microsoft.com/default...d=kb;es;550902

its in spanish, but the code works fine... it messes with
dll's functions and custom types and some other stuff I
don't understand and have never used...

Simply using the code works great but I don't like to use
things I don't understand... I never know when they'll
fail...

If you know of something simpler to do the same I would
appreciate it...

Regards
JS


-----Original Message-----
Take a look at the GetOpenFileName method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Juan Sanchez" wrote in
message
...
Hi all...

Is there a way in VBA to get a path in string format out
of a browser dialog box?... similar to an inputbox that
includes a *browse* button???

Any help is greatly appreciated...

Regards
Juan


.