Hi Experts, How can I get name of all the files exist in one folder through VBA ??? Cheers !!!
I Irfan Khan Aug 26, 2008 #1 Hi Experts, How can I get name of all the files exist in one folder through VBA ??? Cheers !!!
S Sheeloo Aug 26, 2008 #2 Visit http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21863237.html for one solution
Visit http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21863237.html for one solution
B Bob Phillips Aug 26, 2008 #3 A simple Dir loop does it Dim filename As String filename = Dir("C:\test\*.xls") Do While filename <> "" Debug.Print filename filename = Dir() Loop
A simple Dir loop does it Dim filename As String filename = Dir("C:\test\*.xls") Do While filename <> "" Debug.Print filename filename = Dir() Loop
