Hi Guru's

I'm looking for a macro that will look for a specific workbook in a specified folder based on a list. I need it to open the workbook, perform certain tasks, save and close. Then look for the next workbook on the list, perform certain tasks, save and close. I have approx. 80 different workbooks. Is this possible?

Open Income Statement - Act vs Bud - CM located in \\ltcgsrv1\Cognos\Cognos Report Output\Deck Reports, hide columns U-AA, hide columns O-Q and hide columns F-I. Save and Close

THEN

Open Revenue by Client Trended - ENG - TTM located in \\ltcgsrv1\Cognos\Cognos Report Output\Deck Reports, hide columns U-AA, hide columns O-Q and hide columns F-I. Save and Close

So On and So On

Thanks