DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

OLE Excel deactivate cell editing mode

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

0 Kudos
Message 1 of 1
(174 Views)