Browse Button Code to obtain single file name

**Macdave_19** · 05-29-2009, 05:00 AM

Hi All,

i've looked on the threads and there are some exaples of this but not specfic enough.

i need code that allows me to browse my PC for Excel Files then select one file and put it's name into the activecell?

any help is greatly appreciated.

cheers for any help!!

**dominicb** · 05-29-2009, 05:09 AM

Good morning Macdave_19

Originally Posted by Macdave_19

i need code that allows me to browse my PC for Excel Files then select one file and put it's name into the activecell?

How about something like this? It gives the full pathname - is that acceptable?

Please Login or Register  to view this content.

HTH

DominicB

**JBeaucaire** · 05-29-2009, 05:10 AM

Try adding this function and this macro into a standard module, then run the macro:

Please Login or Register  to view this content.

(Function source)

**Macdave_19** · 05-29-2009, 05:21 AM

Thanks to both of you guys, i knew it would be something fairly simple, i should really be able to do this by now!!

cheers

**dominicb** · 05-29-2009, 05:23 AM

Hi JBeaucaire

Think your code is a little larger than it needs to be. Something as simple as this would work to extract the filename only :

Please Login or Register  to view this content.

DominicB

**JBeaucaire** · 05-29-2009, 05:34 AM

Heh... that's a actually a new function for me, never used that before. InStrRev...sweet...text string search from the END of the string.

Thanks for that!