I am having problems with VBA code that uses the PicoHRDL.dll in conjunction with ADC-20 logger.
The Excel application crashes either while the VBA is running or a little while after.
This happens even with the supplied example spread sheet HRDL.XLS. I have tried on three different computers (but with same ADC-20) and get the problem with them all.
Can't tie the crash down to a particular line of code in the VBA, it seems that once the call to HRDLRun(handle, 100, 0) has been made the crash could occure at any time. Sometimes the VBA program will complete and update the spread sheet but still get the "program not responding" message when Excel is exited. When this happens re-running Excel and loading the HRDL.XLS spread sheet gives the spread sheet locked for editing as already in use (by me!!) error. If the ADC-20 is unplugged and re-plugged from the USB port before re-loading HRDL.XLS, then the spread sheet is not locked for editing.