Looping through spreadsheets in a folder and formatting multiple tabs in each spreadsheet
Posted on 2014-04-15
I have a folder which contains multiple spreadsheets each with two tabs. The spreadsheets were created in SAS and exported to Excel. If I have a macro which formats the spreadsheets, can someone tell me how I can go through the directory in VB and format each spreadsheet?
The name of each spreadsheet begins with "Table_"
and the two respective tabs to be formatted end with " _new" and " _all " respectively