richardcarter
Board Regular
- Joined
- Dec 10, 2003
- Messages
- 77
I have created a macro that performs some data cleansing on a .xls file and saves it as a .csv file.
The problem I have is that there are 1,500 .xls files to perform this operation on.
Is there any VBA code that would just simply instruct the macro to "perform this macro on all the .xls files in xxx folder and when it comes to saving them as .csv, use the same filename as the original .xls but save it as a .csv in xxx folder"
Woudl welcome any other suggestions to get round this...
Hope someone can help! Thanks.
The problem I have is that there are 1,500 .xls files to perform this operation on.
Is there any VBA code that would just simply instruct the macro to "perform this macro on all the .xls files in xxx folder and when it comes to saving them as .csv, use the same filename as the original .xls but save it as a .csv in xxx folder"
Woudl welcome any other suggestions to get round this...
Hope someone can help! Thanks.