VBA Macro To Open And Modify Files By Looping Through Files In Folder

[snb]

I don't want to hurt your pride: I think you will be able to amend the code yourself.

[Howardc]

I will certainly give it a bash

[Howardc]

Hi snb & Excel Fox

I have amended my code, but when hiding the row manually and saving and then re-opening , I realised that you cannot hide a column in a CSV file as when it its re-opened the row is no longer hidden