Results 1 to 2 of 2
  1. #1

    Default Importing live data into Excel from CSV File

    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.

  2. #2
    Senior Member MushHead's Avatar
    Join Date
    Jun 2006
    Posts
    504

    Default Re: Importing live data into Excel from CSV File

    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:

    Code:
    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...
    There are 10 types of people in this world - those who understand binary, and those who don't.

Similar Threads

  1. importing data into new partition
    By Ironman in forum PressF1
    Replies: 2
    Last Post: 18-12-2003, 12:30 PM
  2. Replies: 3
    Last Post: 30-03-2003, 12:48 PM
  3. Outlook, Importing old contacts and Inbox data
    By dejohnson in forum PressF1
    Replies: 3
    Last Post: 22-06-2002, 02:51 PM
  4. Importing ASCII files in Excel
    By in forum PressF1
    Replies: 2
    Last Post: 19-04-2002, 10:07 AM
  5. Replies: 0
    Last Post: 15-03-2001, 10:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •