Test and Measurement Forum

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

Forum for discussing PicoLog

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

Postby chris needs help » Fri Feb 23, 2007 1:58 pm

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
chris needs help
 

Postby ziko » Tue Feb 27, 2007 1:20 pm

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 261 times
Ziko

Technical Specialist
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Postby chris needs help » Thu Mar 08, 2007 2:16 pm

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
 

Postby chris needs help » Thu Mar 08, 2007 4:11 pm

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 ?
chris needs help
 

Postby ziko » Fri Mar 09, 2007 2:08 pm

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
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots


Return to PicoLog

Who is online

Users browsing this forum: No registered users and 0 guests