Otto,
I'm creating a program for a chemical-company that automaticly the info coming from process-engineer and it will import the info directy in the process-database by the Apllication-Engineer. (I'm also working there also as a freelance DCS-Application-Engineer)
The process-engineers give the data in excel. The program reads the excel, and compare the data with the existing database.
The program put some colors, conditional formats and comboboxes on the excel, so the engineers see the differences, and can select the data that can be overwriten.
Then the programs reads the excel, and import the data.
For safety-reasons, the network of the Process-engineers and the process-network may not be connected to each other.
So the transfer of data between the process-engineers and the application-engineers is with excel-files.
Otto wrote:Hello Marc,
something off topic.
May I ask why you need to use EXCEL?
I am in our company and with my customers for my saying: "EXCEL is the greatest productivity killer in the company." known.
I don't like these self-made EXCEL solutions in companies.
But there are certainly good reasons to use EXCEL.
Best regards,
Otto