I have been using a picolog1216 to measure the output of a vacuum sensor, converting it to pressure readings and logging to the spreadsheet window provided with the standard download of Picolog. Sampling interval is 10ms, collecting 2600 samples in a 26 second period. One input channel used to measu...

Thanks for the additional information. I'll try this in the future but as with all commercial installations, now it's working I'll not be allowed to test anything new in case I upset somebody's production plans.

I'll use it for the next test setup I have to make.

I've just worked out how to fix this. Took too long to realise that pl1000.dll had to be in the same directory as the original Excel application program (within Microsoft Office\Office 12 on my PC), not the same directory as the workbook I had created with the macros embedded. Guess thats what happe...

I've just got back to this after being diverted onto something else. I tried placing the pl1000.dll in the same directory as the spreadsheet I'm using, it doesn't work. I get a "Run-time error '53': File not found: pl1000.dll" message from Visual Basic and the Debugger starts. Everything was working...

I've put together some test equipment using Picolg 1216 and a Windows XP computer. It runs from an Excel workbook using VBA macros to trigger the test event via a digital output and collect data through USB to the spreadsheet. Everything works well but the user now wants two of them working on one P...

I have built some test equipment around a picolog 1216. It works in conjunction with Visual Basic routines called from Excel macros to transfer data directly into the workbook for analysis. I have to build a duplicate system for installation on another PC. The prototype was built with MS Office runn...

Thanks for the example code, made me look again at the syntax I was using and the names I was giving to variables. I think I made the mistake of using the same name for a variable that the compiler was using as a place-holder which stopped the program compiling correctly. Everything does what I want...

Thanks for this, got the Excel VBA example working fine as far as transferring data is concerned, without too many problems. Now I want to go on and use the digital outputs to turn indicator lights on and off but I'm having trouble using the pl1000SetDo routine within the Excel macro. It doesn't see...

I am building a test system that measures the output of a sensor as a voltage with a Picolog 1216 (using one input channel). The device being tested is put through its paces by a pneumatic actuator driven by a PLC. The PLC also generates a trigger signal to another channel on the Picolog. I am runni...