I'm using the Excel GetAdc11 macro which is supplied with the ADC11 unit. All works fine ... however I would like to be able to re-run the macro after it has been executed. If I do this at the moment it says Unable to open ADC (and I have to close Excel and re-open it before it works again).
I've tried to call adc11_close_unit subroutine... to close the active "connection" to the ADC11 device...but I couldn't seem to get it working.
Is there a way to automatically close this "connection" after the macro has run ... so that the macro can be re-run at a later time (without restarting the.xls file).