-1
I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch of time. I'm hoping to add onto or even change the program so that I can perform real time calculations with the data collected.
Is it possible to live stream data being stored to a *.csv file to an excel spreadsheet and if so how would one do it in VB? I'm writing a macro to constantly run in the background of the spreadsheet to perform the necessary calculations as new data is being imported.
P.S. I did not write the original program and am still extremely new to coding so I'm still trying to make sense of everything myself
1You may find issues about streaming to the file and accessing the file at the same time!! Is this VB6 or VB.net? – Dave – 2015-06-30T14:56:46.150
OLE/Automation is a method used for inter-application communication. Excel can be set up to get the data from the application itself rather than via an intermediary text file, but you will need to set up the original program to support it also. – Yorik – 2015-06-30T15:18:06.347
start learning databases. Sqlite3 for example. – befzz – 2015-06-30T21:02:02.507