Let you guys updated. The problem has been solved by using DDE. Both software C and excel accept DDE.Thank you all.
Need to read data from a .txt file dynamically. How to keep the .txt file autosaved?
Software C needs data dynamically from software A ( data acquisition system). Software A can dynamically (once 20 seconds) export data to Excel file B. B needs to be saved as .txt file and then to be read by software C (C can not read directly from .xls file).Now, the probelm comes. C can not read .xls file but can reasd .txt file. How to make the B in .txt format updated every 20 seconds automatically in ordor to let C to read the data dynamically. Hope I explain it clearly. Excel file can be saved as .txt file, and when this file is kept opening, the data is dynamically updated, but not saved. C can only read the .txt file saved.
Basically, how to make a .txt file autoupdated or autosaved? Thanks a lot.
Need to read data from a .txt file dynamically. How to keep the .txt file autosaved?
Software C needs data dynamically from software A ( data acquisition system). Software A can dynamically (once 20 seconds) export data to Excel file B. B needs to be saved as .txt file and then to be read by software C (C can not read directly from .xls file).Now, the probelm comes. C can not read .xls file but can reasd .txt file. How to make the B in .txt format updated every 20 seconds automatically in ordor to let C to read the data dynamically. Hope I explain it clearly. Excel file can be saved as .txt file, and when this file is kept opening, the data is dynamically updated, but not saved. C can only read the .txt file saved.
Basically, how to make a .txt file autoupdated or autosaved? Thanks a lot.