Quantcast

Maximum PC

It is currently Thu Dec 25, 2014 3:01 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Realtime Excel Data Capture
PostPosted: Mon Jan 18, 2010 3:20 pm 
8086
8086

Joined: Sat Jun 07, 2008 9:28 am
Posts: 1
Ok, here is my problem. I have may rows and coloums of data being fed into an excel spreadsheet. What I am needing is to know how to either make excel print certain rows into a new sheet or other SQL database. Such as print the data ever 1 or 5 minutes.

My live data comes from DDE and I dont know if I have to make a macro to do this or if it is an excel function to print to a new sheet at a certain interval. I have looked all over the net and maybe I am phrasing my question wrong but I come up with no results on how to do this.

Thanks.


Top
  Profile  
 
 Post subject:
PostPosted: Wed Jan 20, 2010 9:17 am 
Team Member Top 100
Team Member Top 100

Joined: Sun Feb 12, 2006 2:52 pm
Posts: 1994
Location: Cryptogram City!
Insert a program to do what you want, between the source, and the Excel spreadsheet:

Source >> Your program >> Excel spreadsheet

I don't know if Excel will do what you want, on it's own.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

© 2014 Future US, Inc. All rights reserved.