For my previous question (see the end of this post), I was suggested to do the following:
用 Excel VBA 构建个 Form, 然后设置 timing 控件的时间间隔.
Excel VBA 可以把要求的Excel 的cell写到文本/随机文件中.
I tried the Excel VBA but had no idea how to use it. Can anyone please give me a brief course?
-------------------------------------------
Previous question:
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.
用 Excel VBA 构建个 Form, 然后设置 timing 控件的时间间隔.
Excel VBA 可以把要求的Excel 的cell写到文本/随机文件中.
I tried the Excel VBA but had no idea how to use it. Can anyone please give me a brief course?
-------------------------------------------
Previous question:
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.
