Hope to get some help.
I will start to apologize for my bad English.
I’m working on a project where I want to get the results from counter one into an excel sheet. Where it’s going to show performance for a staking unit. I have looked in the tread
But my programming skills are “this is the first time” and I have the same problem whit “Invalid use of AddressOf operator” is there anyone who have a solution for this problem, is there a plug-in or something else I am missing? I’m using Excel 2007 enterprise.
Hi vontraubeck
you haven’t said what programming language you are using. I have downloaded Visual Express 2008 from Microsoft and if you run Visual Basic 2008 on the Vellerman example code it will convert it to Visual Basic 2008. From memory it uses Timer1 to read the counters. You can read the counter and store the result in a Textbox and then open or create an Excel workbook and put it into that. If you search the internet for saving in Excel you will find a lot of examples. Alternatively if you only wants one sheet in the workbook you can store it as a Comma separated values file and read it with excel. If you want examples of code you can email me on gwally@netspace.net.au and I can send you sample of what I have done. Hope I got this right I am pretty new at it too. If you can do it some other way than with Excel I would suggest you do that, Excel takes a lot of time reading and writing.
Hi Gawally
Thank you for your response, I have no experience programming, but I would like to see what you have done whit the board. Hope it’s not too much trouble for you. I have send you a mail.
Well the case for me is that I want to make some different calculations whit the count, that would for an example be to compare the count whit a solid number, that could be converting the count to a percentage of pre selected number, and then show I graphically like a diagram. to make it a little more difficult I hope I can make it so it are continuously updating maybe every minute or something like that.
In the tread I’m linking to it’s visual basic applications there are being used, I think. But I couldn’t just copy paste the code, well I could, but it did not work, I got the error message “Invalid use of AddressOf operator” but I cant solve the problem, us so if any other types of coding can be use I’m game.
Hi vontraubeck
Have emailed you what I have done. I don’t use AddressOf operator at all mine is all done in Visual Basic Express 2008 with Windows Forms. Timer times can be set easily and also ticks can be read and counted easily.