morinia
asked on
Looping through spreadsheets in a folder and formatting multiple tabs in each spreadsheet
Experts,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
At best from another excel workbook not one you are trying to change
ASKER
Pardon my ignorance, but I know what to input for Folder Name. Can you tell me what is
& ObjFile.Name
& ObjFile.Name
the code will present you with a folder selector dialog
you only have to replace the 26 with your code
you only have to replace the 26 with your code
ASKER
Where do I execute this macro from?