Picologger ADC-11 Macro

Sulphurette · Post by **Sulphurette** » Fri Mar 11, 2005 1:53 pm

I am trying to write a macro in Microsoft Excel but have never done this before.

What I want to do is start logging when a light gate is tripped, record data from a halls sensor to find the revs per second from the number of dips in the voltage, then stop logging when the second light gate is broken.

Does anyone have any example macros I could use as a basis, or know where I can find/download one?

Many thanks

Sarah · Post by **Sarah** » Mon Mar 14, 2005 9:33 am

Hi

Thank you for your email.

You can download the example files that we provide from:

http://www.picotech.com/software.html

There should be drivers and an Excel example in the ADC-11 bundle.

Hope this helps

Best Regards

Sulphurette · Post by **Sulphurette** » Wed Mar 16, 2005 12:22 pm

Hi Sarah,

I could not find anything useful on the webpage link. I have treid downloading and using the PicoScope but only seem to be able to log as fast as I want.

I would still ideally like to use an excel macro, but could not fi d any examples.

There is mention of them in the manual, and a giude, but having never used macros before is not very helpful. There is also a link on the webpage, but it does not go anywhere.

Sarah · Post by **Sarah** » Thu Mar 17, 2005 11:27 am

Hi

Thank you for your post.

The Driver and Manual download on that page is what you want (at the bottom) - this includes the examples for a number of programming environments.

Try downloading that and see how you get on.

Best Regards

Test & Measurement Forum

Picologger ADC-11 Macro

Picologger AC-11 Macro

Excel example from Sarah