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