Reading text file into excel automatically

[ugoneman]

How do i read a text file into excel automatically anytime the text file is updated. I have a text file that is updated every 100 times a minute from the hyperterminal text capture. I want to read it into excel 100 times a minute?

[Killer42]

How do i read a text file into excel automatically anytime the text file is updated. I have a text file that is updated every 100 times a minute from the hyperterminal text capture. I want to read it into excel 100 times a minute?

Were you thinking of driving this from within Excel, or from a separate application, or what?

[Killer42]

At the simplest level, I suppose you could have a VBA macro in Excel which just keeps looping, issuing DoEvents to allow other things to happen, and checking the file once every however-often.

Here's something off the top of my head...

Public Sub DoSomething()
  Const TimesPerSecond As Double = 100
  Dim Interval As Double
  Dim WaitUntil As Double
  Interval = TimeValue("00:00:01") / TimesPerSecond
  Do
    WaitUntil = Now() + Interval
    Do
      DoEvents
    Loop Until Now >= WaitUntil
    ' Do your thing here...
    Beep
  Loop
End Sub

There are probably heaps of things wrong with this, but it should be enough to illustrate the idea, anyway.

[ugoneman]

Thanks for the reply.I still have a little problem, I have not programmed with visual basic before but i need this for a small project. Is it possible for me to get a complete code of how I could load a text file, say ggg.txt 100 times per second into excel. That is anytime the file is updated it is uploaded into excel.

At the simplest level, I suppose you could have a VBA macro in Excel which just keeps looping, issuing DoEvents to allow other things to happen, and checking the file once every however-often.

Here's something off the top of my head...

Public Sub DoSomething()
  Const TimesPerSecond As Double = 100
  Dim Interval As Double
  Dim WaitUntil As Double
  Interval = TimeValue("00:00:01") / TimesPerSecond
  Do
    WaitUntil = Now() + Interval
    Do
      DoEvents
    Loop Until Now >= WaitUntil
    ' Do your thing here...
    Beep
  Loop
End Sub

There are probably heaps of things wrong with this, but it should be enough to illustrate the idea, anyway.

[Killer42]

Thanks for the reply.I still have a little problem, I have not programmed with visual basic before but i need this for a small project. Is it possible for me to get a complete code of how I could load a text file, say ggg.txt 100 times per second into excel. That is anytime the file is updated it is uploaded into excel.

I think you need to be more specific about what you mean by "loaded". For example, if you were going to load it manually, would you

• Simply open the file in Excel?
• Paste the text over the top of existing data, replacing it?
• Append the the text onto the end of existing data?
• Load the text into a new worksheet within an existing workbook?

There are just too many options for the "what" for us to start advising you on the "how".