Hi guys,
I've got a folder with 17,000+ csv files. I'm trying to write some kind of script that will loop through all the files and delete unwanted data to reduce file size.
The range I need to delete varies. So it needs to look in column J and go down until it reach the row where the cell becomes empty, then clear everything (all rows and columns) below that.
Any ideas on how I can do that?
After a bit of Googling I found some tutorials on Dir loops. But they were all for compositing file names, not quite what I need. I learnt a bit of VBA years ago but have forgotten everything now
Appreciate the help!
I've got a folder with 17,000+ csv files. I'm trying to write some kind of script that will loop through all the files and delete unwanted data to reduce file size.
The range I need to delete varies. So it needs to look in column J and go down until it reach the row where the cell becomes empty, then clear everything (all rows and columns) below that.
Any ideas on how I can do that?
After a bit of Googling I found some tutorials on Dir loops. But they were all for compositing file names, not quite what I need. I learnt a bit of VBA years ago but have forgotten everything now
Appreciate the help!