Name of files in a folder
 

Hi Experts,

How can I get name of all the files exist in one folder through VBA ???


Cheers !!!

Name of files in a folder
 

Visit
http://www.experts-exchange.com/Prog..._21863237.html for one solution

"Irfan Khan" wrote:

Hi Experts,

How can I get name of all the files exist in one folder through VBA ???


Cheers !!!

Name of files in a folder
 

A simple Dir loop does it

Dim filename As String

filename = Dir("C:\test\*.xls")
Do While filename < ""

Debug.Print filename
filename = Dir()
Loop


--
__________________________________
HTH

Bob

"Irfan Khan" wrote in message
...
Hi Experts,

How can I get name of all the files exist in one folder through VBA ???


Cheers !!!