|
|
| Author |
Message |
chris needs help
Guest
|
 Posted: Fri Feb 23, 2007 1:58 pm Post subject: how can i auto save data after each cycle in the spreadsheet |
 |
|
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.
please help
Chris
|
|
| Back to top |
|
 |
ziko
Site Admin
Joined: 01 Dec 2006
Posts: 667
Location: St Neots
|
| Posted: Tue Feb 27, 2007 1:20 pm Post subject: |
|
|
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.
Kind regards
| Description: |
|
Download |
| Filename: |
usbadc11.xls |
| Filesize: |
36 KB |
| Downloaded: |
106 Time(s) |
|
|
| Back to top |
|
|
chris needs help
Guest
|
| Posted: Thu Mar 08, 2007 2:16 pm Post subject: |
|
|
Hi Ziko
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
thanks for your help
chris
|
|
| Back to top |
|
|
chris needs help
Guest
|
| Posted: Thu Mar 08, 2007 4:11 pm Post subject: |
|
|
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 ?
|
|
| Back to top |
|
|
ziko
Site Admin
Joined: 01 Dec 2006
Posts: 667
Location: St Neots
|
| Posted: Fri Mar 09, 2007 2:08 pm Post subject: |
|
|
Hi and thank you for your post.
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:
http://www.cpearson.com/excel/ontime.htm
Kind regards
Ziko
|
|
| Back to top |
|
|
|
Cart
Email