Use Application.Filesearch

HTH
--
AP

"funkymonkUK" a
écrit dans le message de news:
...

Hi

I want to create a sheet which shows the current main folder in a cell.
I know of getopenfilename in vba but there the user has to specify the
file as well where I just want the folder.

How do I get a list of Files which are in a specific folder? As I want
to create a list of them and then open them up, extract some data and
then close them.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=537997