How can E3 communicate with Excel?
There are two possibilities:
- Using DDE driver (which is indicated when you just need to exchange data between E3 and Excel);or
- Using ADO connection (which is indicated when you need Excel to work as a Database).
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.