| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 109709 | 2010-05-19 23:35:00 | Importing live data into Excel from CSV File | zqia014 (13726) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 886275 | 2010-05-19 23:35:00 | Hi all, Does anybody know how to do this? I have a recording system that generates .csv files and I need analyze them in Excel 2007. I can manually import them while it's recording and refresh it once in a while to get new datapoints. But how would I get Excel to automatically update it? It takes a recording every second so I would like Excel to automatically update every second, without me having to click refresh. Thanks for all suggestions. |
zqia014 (13726) | ||
| 886276 | 2010-05-20 02:11:00 | I've just thrown this together - probably needs some way of stopping the run without opening up the VB editor... In the "Sheet1" (insert your name here) worksheet's code area, put this: Public Sub Recalculate() ThisWorkbook.ActiveSheet.Calculate End Sub ' This is called after a recalculation Private Sub Worksheet_Calculate() Application.OnTime Now() + TimeValue("00:00:05"), "Sheet1.Recalculate" End Sub In my example, the worksheet recalculates every 5 seconds. Probably needs a bit more fleshing out, but hopefully is the way to do it... |
MushHead (10626) | ||
| 1 | |||||