Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Real Time Data
Hi,
RTD is placed into an Excel 2007 cell via an Add In. This data is updated at random times. I would like to capture this data every minute and place it in another cell in the same Worksheet. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Real Time Data
Here I go again. Last time I answered one of these it turned into a full out
development effort. Ain't happening again!! But... You can set up an event to run at specified intervals. One of the better coding examples for it is Chip Pearson's code to make the text in a cell blink. That code is called once per second, you'd just want to change the interval to 60 seconds, and of course you'd replace the code in Sub StartBlink with the code to capture your data and move it to the other cell(s). Here's the page with Chip's (in)famous blink cell text code: http://www.cpearson.com/excel/BlinkingText.aspx Other considerations: be very certain that you reference ThisWorkbook when referencing worksheets and cells on them because if you happen to be working in another workbook when the routine runs, it's going to use the current active workbook's sheets/cells if possible, and probably error out if not, unless your code is very specific about pointing to the workbook the code is running from. You might consider replicating the code in the Workbook_Open() and Workbook_BeforeClose() events in the Workbook_Activate() and Workbook_Deactivate() event procedures. "Rob" wrote: Hi, RTD is placed into an Excel 2007 cell via an Add In. This data is updated at random times. I would like to capture this data every minute and place it in another cell in the same Worksheet. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Real Time Data
"JLatham" wrote: Here I go again. Last time I answered one of these it turned into a full out development effort. Ain't happening again!! But... You can set up an event to run at specified intervals. One of the better coding examples for it is Chip Pearson's code to make the text in a cell blink. That code is called once per second, you'd just want to change the interval to 60 seconds, and of course you'd replace the code in Sub StartBlink with the code to capture your data and move it to the other cell(s). Here's the page with Chip's (in)famous blink cell text code: http://www.cpearson.com/excel/BlinkingText.aspx Other considerations: be very certain that you reference ThisWorkbook when referencing worksheets and cells on them because if you happen to be working in another workbook when the routine runs, it's going to use the current active workbook's sheets/cells if possible, and probably error out if not, unless your code is very specific about pointing to the workbook the code is running from. You might consider replicating the code in the Workbook_Open() and Workbook_BeforeClose() events in the Workbook_Activate() and Workbook_Deactivate() event procedures. "Rob" wrote: Hi, RTD is placed into an Excel 2007 cell via an Add In. This data is updated at random times. I would like to capture this data every minute and place it in another cell in the same Worksheet. Thanks. Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Trend Data over time | Excel Discussion (Misc queries) | |||
creating dataseries from real time data | Excel Worksheet Functions | |||
Data from two sheets make up a list in a third sheet (real time) | Excel Worksheet Functions | |||
storing real time data | Excel Discussion (Misc queries) | |||
Excel 2003's autosum does not update data in real time | Excel Worksheet Functions |