Home > Forum Home > Automating Data Analysis Tasks > Creating a continuously updating excel document Share

Creating a continuously updating excel document

Excel Help for Creating A Continuously Updating Excel Document in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Creating A Continuously Updating Excel Document

Rate this:
(3/5 from 1 vote)
Confusedmy company has asked me to create a continously updating excel document. we use a program that creates a log file in a csv format that is updated about every 3 to 5 minutes.  As you can guess this makes for a very large file in a very short time. what they want is to be able to access the data in the log via excel. they also want the data to be imported into an access database every night and have the log file reset so that its size doesnt  get to large, and to have this archived data available to. but they want the current days data as close to real time as possible.  is their a way to create a single document that can be accessed by everyone to show this data in realtime in excel or access?
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
You can read from a CSV or text file within Excel VBA code by using the FileSystemObject to read from the file line by line and then do what you like with the data read in Excel. e.g.

VBA Code:
Dim fso As New FileSystemObject
Dim fld As Folder
Dim ts As TextStream
Const ForReading = 1, ForWriting = 2, ForAppending = 8

Set ts = fso.OpenTextFile("C:\Temp\temp.txt", ForReading)

While Not ts.AtEndOfStream
    Debug.Print ts.ReadLine
Wend

ts.Close

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Creating a continuously updating excel document in the