Hello community,
I'm using OLE commands found in several examples to open an Excel workbook and write text into cells.
The problem I'm facing is that I cannot find a solution to access Excel if an Excel cell is in editing mode (user did double click or pressed F2 in Excel).
Apperently Diadem doesn't generate an error, it just waits until the cell is closed in Excel.
I tried:
Excel.Workbooks("Test").Sheets("Tabelle1").SendKeys "{Enter}"
Excel.Workbooks("Test").Sheets("Tabelle1").Cancel=true
Both lead to an Diadem error.
Do you have any idea?
Many thanks
Stefan
