I have an Excel spreadsheet and it has a header row. The header row
describes what is in the rows beneath. It just so happens that the format
may be changed from time to time because we receive these Excel spreadsheet
files from a different company. The macro I am trying to create spits out a
..txt or .rdf file with hard coded text and records from the spreadsheet.
There are 15-17 columns of records that I am reading from and over 1500
records. How would I be able to code this vba program so that it spits out a
record based on it's header? The vba code has hard coded text that shows
what each record field is, how would I code this program based on that?