I know there are ways to alter the attributes of a column in a table and I have done that.
What I want to do now is from within VBA load the table then alter the names of some of the fields in the table after I know the data that is loaded into them.
I want to export the table to an excel spreadsheet. When I do that the names of the fields are used as column headers. I want to chnaae the names of the fields to represent what is in the column so the exported spreadsheet has the correct column names.
Any given experiment will be tested against different materials. Some experiments may test against only two materials, some may test against 5.