Hello ALL,
I have a need for a macro that will open up all text files (with extension .csv) in a directory, find lines that have a cell entry of **** Header Line ****
and then delete those lines, close and save the files. There is only one column containing the string, col "J". The number of lines with a cell containing this string will vary as will the number of files.
There are 52 diff columns on each file and each are in the same format.
Any assistance would be gratefully recieved!
Thanks and have a great day....
Dan
I have a need for a macro that will open up all text files (with extension .csv) in a directory, find lines that have a cell entry of **** Header Line ****
and then delete those lines, close and save the files. There is only one column containing the string, col "J". The number of lines with a cell containing this string will vary as will the number of files.
There are 52 diff columns on each file and each are in the same format.
Any assistance would be gratefully recieved!
Thanks and have a great day....
Dan