12-22-2016, 11:08 PM
Hi -
I'm new to QM, but not new to programming.
I have a simple macro that is automating some data entry. I need the macro to loop through a list of values (value a, value b, value c) and execute once for each value. The list could be quite long and will change each time I need to execute it.
If I was doing this in VBA, I would create a recordset, go to the first record and incrementally get the values as I need them.
Is there a trick in QM that makes this easy (i.e., use a simple list of values in a txt file, .csv?, Excel?, Access?)
Any ideas?
Jason
I'm new to QM, but not new to programming.
I have a simple macro that is automating some data entry. I need the macro to loop through a list of values (value a, value b, value c) and execute once for each value. The list could be quite long and will change each time I need to execute it.
If I was doing this in VBA, I would create a recordset, go to the first record and incrementally get the values as I need them.
Is there a trick in QM that makes this easy (i.e., use a simple list of values in a txt file, .csv?, Excel?, Access?)
Any ideas?
Jason