external updating EXCEL data

[stefandk63]

Hello ,everybody,
i have task as follow:
- some data is collected regularly and written to file by my program, written in C. Each update contains 7-8 different numbers. Time to time user wants to review collected data. Problem arises , when user does not close file for long time - file can't be updated.

First approach ,i did try , was to open in Excel file as READONLY. But when file is changed, Excel did not ask for reloading.
Second approach was to use DDE link. I compiled simple server (found it here http://www.ehow.co.uk/how_7481925_run-excel-dde-server.html. DDE link for single cell is ok. After this i stopped - do not how to write and where to write correct formula for multiple cells. I suppose (from DDE server side) one data item will contain many numbers - there is XLt-table format for data transfer to Excel client. How to define and connect region of cells (in Excel side) to this data item is mystery for me.

Any advise will be great help for me, thanks.
Stefan

[tigertiger]

Plz, try to find the way to solve the problem in the bellow links
http://excel-dna.net/2011/04/28/fina...ith-excel-dna/
http://exceldna.codeplex.com/

hopes that are useful 4U

[stefandk63]

Problem solved trough Excel->dataimport ->query... User opens 'book1.xls' , which imports logfile (.csv type - comma separated text). Sorting is stored and doesnt need user intervention. While constructing 'book1.xls' Excel asked for 'Microsoft query' to be installed. But final file contains all info needed, so ExcelViewer works allmost fine, without 'MS Query' installed. It seems .xls and .csv files can be delivered to end user as email.