Okay, I see now that you can specify the column name using the DDTDriver. The problem I'm running into has to do with losing my open connection to the excel file. Initially it works fine. I had a problem early on with multiple excel processes being left open, so I added a line to my 'Private Sub Class_Terminate()' Event so that anytime an object is set to 'nothing' it would also terminate any lingering excel processes. If I didn't do this then before long I'd have multiple processes running and it would get out of sync.
But now that I'm attempting to loop through a recordset of test data that then injects this data into the same framework flow, once one of the lines that sets an object to 'nothing' gets run it terminates my excel process causing my recordset to lose its connection to the file.
So, would using the DDTDriver remedy this? Can I create recordsets, or can I continue to access the data in the excel file without having to maintain an active connection?
