Then loop that for however many variables I have left.
So right now I've built a form that I can copy/paste the html code into that assigns a row number (autonumber) for every line of code. Then I can just click which lines of code (yes/no box) that need to be customized and the original code I pasted into my TEMP table is appended to their appropriate tables: tbl_FileCode and tbl_FileCode_Custom
It would be relatively easy at this point to just set up a query for each custom line of code and append the custom code (along with its original row number) and uncustomized code to another TEMP table, sort ascending on the query and export it. But that just seems wasteful to have to create a query for every line of code I want to customize.
Is there a better way of doing this that someone can point me in the right direction please?
PS: I love you.
EDIT: I just realized I didn't explain the customized codes correctly. The lines of codes have variables in them from a table. So I can't just simply associate the row with the line of code. So it's like this (if this makes sense):
Row5: "<p>Howdy, " & [firstname] & "how are you?</p>"
Then all the custom lines of code and un-altered lines of code get appended to a TEMP table, sorted ascending (so all the lines of code are in order) and then exported. I'm just having a hard time structuring this with queries and may need to code up something in VB so I don't have 40million queries.