how can i auto save data after each cycle in the spreadsheet

Forum for discussing PicoLog
Post Reply
chris needs help

how can i auto save data after each cycle in the spreadsheet

Post by chris needs help »

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

ziko
Advanced User
Advanced User
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Post by ziko »

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
Attachments
usbadc11.xls
(36 KiB) Downloaded 639 times
Ziko

Technical Specialist

chris needs help

Post by chris needs help »

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

chris needs help

Post by chris needs help »

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 ?

ziko
Advanced User
Advanced User
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Post by ziko »

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
Ziko

Technical Specialist

Post Reply