mhenk
Well-known Member
- Joined
- Jun 13, 2005
- Messages
- 591
Hi guys, I have some formatting changes I need to make to 20 large excel files, all located in the same folder (some .xlsm, some .xlsx):
1) Delete Rows 1:42
2) Reformat all cells to numeric form "general"
3) Save as CSV file (same filename, new extension).
This is easy enough to record and do for one file, how can I loop through all (XL) files in a folder and do the same thing?
Thx.
1) Delete Rows 1:42
2) Reformat all cells to numeric form "general"
3) Save as CSV file (same filename, new extension).
This is easy enough to record and do for one file, how can I loop through all (XL) files in a folder and do the same thing?
Thx.