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
Bookmarks