[请求] solved ".txt" file autosaved?

[laoli]

Excel and software C both accept DDE. I download a DDE program .vi file and load in program C. It works. But not to autosave the .txt file, just directly communicate each other.

Thanks

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.

 

[terrence]

用 Excel VBA 构建个 Form, 然后设置 timing 控件的时间间隔.
Excel VBA 可以把要求的Excel 的cell写到文本/随机文件中.

 

[laoli]

最初由 terrence 发布
用 Excel VBA 构建个 Form, 然后设置 timing 控件的时间间隔.
Excel VBA 可以把要求的Excel 的cell写到文本/随机文件中.

Sounds there is a way to do it. Thanks.

I mainly use Excel for data analysis, do not know how to use program function. What is VBA and how to use it? I searched help and guess to use "Visual Basic Editor". It looks too complicated for me. Is it hard to learn. Thanks ahead.

 

[laoli]

up

 

[Emperor]

Maybe it is stupid idea: use another program or Macro to run software A, B and then C in sequence.

 

[laoli]

Solved

Excel and software C both accept DDE. I download a DDE program .vi file (41kb) and load in program C. It works. It is not to autosave the .txt file, just directly communicate each other.

Thanks