Pico Technical Support and Discussion Forum

inschris

Greetings all. I'm writing a macro (VBA) in Excel 2000, win98se. The macro will use the adc11 to collect data. Crashes during runs of the macro (including debugging) are not uncommon. Then I see msg "Excel This program has performed an illegal operation and will be shut down". When I acknowledge (click on Close), Excel and the macro shut down. But the adc remains on, ie the LED thereon remains on. It is not possible to restart Excel and again run the macro, even if I have disconnected the adc11, then reconnected; instead, when I again try to run the macro, or to run PicoLog, there is the same msg or other hangup.

In general, I can again run the Excel macro, or PicoLog, only after a restart. Is there some way of resetting the usb adc11 and/or windows' related setup without restart, so that the Excel macro, or PicoLog, will again be able to open the adc11?

Thanks in anticipation.

ziko · Posted: Tue Jan 30, 2007 3:12 pm Post subject:

Hi thank you for your post, which device are you using, the Parallel ADC11 or the USB one.

Kind regards

inschris · Posted: Tue Jan 30, 2007 6:23 pm Post subject:

In response to Ziko, 30 January 07:
I have a USB ADC11/10.
Following are the particulars when I run Sarah's C Console Application for the USB ADC11/10:
1.0.1.6
USB 1.1
1
USB ADC-11/10

Following are the particulars when I run the Pico example USBADC11.xls:
USB 1.1
1
USB ADC-11/10
GFY6448 (?serial number?)

Thanks in anticipation. Keep well.

ziko · Posted: Mon Feb 05, 2007 3:26 pm Post subject:

Hi and thank you for your post.

I do not quite understand the problem. Could you try running the following macro in the attached file.

Kind regards

Ziko

Pico Technology

Pico Technical Support and Discussion Forum