Excel: How to loop through entire workbook performing the same Sub
Posted on 2014-08-06
Hello, I'm working with Bloomberg data in excel, and have a vba program that will effectively force refresh bloomberg data, allow it to load, all that. My issue is that I'm unable to have the program perform the same Sub on every sheet in a workbook. I've tried numerous solutions I found on the internet, but none seem to loop through each worksheet.
My request: My goal for this program is to have a Sub loop through each worksheet and perform the BloombergRefreshLinks Sub and its accompanied sub procedure ProcessData.