Hi, for some time I have been looking for easy ways to interface the K8055 with Excel to use it with Excel VBA. This provides the advantage of Excel to use as a data log store and you can build a control interface using Excel formula logic.
I have not found a way of doing this using the standard DLL but I thought I would offer my discovery of an ActiveX component that you can embed into an Excel worksheet and use this to interface with the USB card.
The ActiveX component is the IOGateway from Industrial Might and Logic Ltd. This software component has been around for some time, it costs approx $30US, but has enabled me to do more or less what I wanted to do given that I don’t know any programming languages apart from various flavours of Microsoft VBA. The component needs to instal iteslf on the host computer, enable Excel macros, and then you need to set a reference to it in the VBA editor. After that it follows a fairly standard VBA object model that I was able to work out by trial and error.
If anyone is interested to know more I will write a description of the project setup and supply a copy of the Excel workbook I have developed as a hobby project. It currently contains a data logging program that records the inputs in an Excel data table format and it has a Halloween project which triggers various outcomes in respone to any of the 5 inputs being triggered. I have used it to contol relays connected to props, LEDs, and to play a random worksheet embedded media files. The latter was fun connected to some outdoor speakers so that when someone arrived at the door they broke a light beam that turned on a strobe light and played a random Halloween sound. A questionable use of time but good fun working it all out.
Hi, I have not had enough free time to add any notes but you are welcome to have a copy of the file to work out what I have done. If you are proficient with Excvel VBA you should be able to make sense of it.
I am trying to find a way of uploading the file but cannot find a button to let me do so. Any ideas on how to get it to you?
I have not been onto this forum for a long time so apologies for not replying sooner about sending out the sample Excel file I have as requested.
I do not have any problem sharing the VBA code that I wrote but the workbook contains an instance of an embedded ActiveX component called IOGateway which I purchased for approx. $30 and is licensed to me. The site I bought it from appears to have been abandoned but I don’t want to release a copy of the IOGateway install file without which the embedded component will not work.
Also having recently opened the Excel file after a long period of inactivity I found my anti-virus software had a problem with the ActiveX component and immediately moved the file to a virus vault. It took a bit of effort to add an exception to the AV so that I could actually work with my own file.
If there is still any interest I will share the file which is currently set up to drive Halloween props but it also has some not very robust code that could be modified for many types of data logging projects.