Question:
How can E3 communicate with Excel?
Solution:
There are a few possibilities:
- Using DDE driver (which is indicated when you just need to exchange data between E3 and Excel);
- Using ADO connection (which is indicated when you need Excel to work as a Database);
- Using the object EXCEL.APPLICATION.
NOTE: attached to this article, there is a demo application that shows how to get data from an Excel spreadsheet creating an ADO connection via scripts.