Hi, I'm a beginner so any help would be appreciated.

I've written a nice macro that will extract all the info i need from one workbook and do the necessary calculations. Now I have to run that macro on about 150 workbooks. Is there any way to speed this process up? All the workbooks are contained in subfolders of one big folder:

Folder(AllIndustries)
Folder(Airlines)
Folder(Auto)
Company(a)
Company(b)
Company(c)
Folder(Capital Goods)
Company(x)
Company(y)
Company(z)

and so forth...

So basically is there a way to write a code that will open up all the files in the big folder and run the macro without having to write the path names for all 150+ companies?

Thank you very very much for any help.

Joey