I have a reoccurring daily delimited text file that has a variable sized header. The programmer uses a row with "------------" to indicate the end of the header. I'm trying to write some VBA to delete these rows prior to running it through the Import VBA Code. I've successfully used the below code to delete a fixed number of rows in another circumstance; however, I'm not sure where to begin to add a logic component to test for the existence of the end of header characters.
Could someone provide some direction or hint?
Bookmarks