The one thing You must understand is that the Excel is Master (or Client, if You prefer) in this communication type and Freelance system is Slave (because you connect to OPC server). With that in mind I would recommend changing the VBA code so that a BOOL variable with Your status bit is read cyclic and on value of TRUE You read other variables and reset the status bit. It requires some tinkering in VBA code, but the app you are linking is a good starting point.
Hope it helps, but if You need some more help just ask.
in addition to above answer have you check freelance batch solution?, Freelance Formulation.
Check at this link @
Might be the solution you are looking for, it's having recipe management as well as reporting for batch kind of application.
Hope that helps...