Open excel docs from a folder

[Malc8179]

Hi Guys

I have 980 excel docs in a folder i want to run a script in excel that will open each file in turn copy the file name store the the file name in a list

im able to copy the file name and store the file name i am stuck with opening the files from the folder in turn

 

[PHV]

Have a look at the Dir function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ettienne]

Look at the Dir() function in VBA.
If you have Excel files in C:\My Folder then do something like:

Dim strFile as String
strFile = Dir("C:\My Folder\*.xls") 'returns first file

Do While strFile <> ""
strFile=Dir 'note no parameter
loop

 

[Malc8179]

Thanks Guys

This did the trick for me