Hi i want to automatically save the data collected (from my adc-11) into the spreadsheet format, i.e. in the text file so i will be able to automatically import the data into acess without having to manually save hundreds of files a day.
Hi and thank you for your post. There is no way to automatically do this using our software, however once you have done your data collection, in spreadsheet mote if you click on the first icon you can save your selected results in a text file.
If you are prepared to write your own software you can record your measurements in excel using a macro. If you do a custom installation you will can install examples for the ADC11 (Excel macro for the parallel port version). If you are using the USB ADC11 please find attached the example file.
thanks for the macro you supplied I have been messing about with it but i was wondering if the following would be possible:
1) could the time the sample taken be the actual time instead of time since start of macro
2) could the macro last longer or (prefferably run once a second taking only 1 reading indefinately) as when ever i increase the time for the macro to run by too much it just crashes excel
Please disreguard last post I have managed to get the program to do what i want.
I am a complete novice when it comes to programming so maybe some one will know how i can get my sub to be called once every second? at the moment my macro just puts the time and date and the value at each channel on a new line but i have to click to get the next value, is there anyway to automate this say every second for an hour ?
We cannot help you with writing your code, what we do provide is examples and drivers to help you to achieve your objective. You will have to incorporate a timer into your code. This link may be of help to you: