>I am doing ole with fox to automate excel. Everything is fine until the user make some change and don't apply the change to the cell (doing enter key or mouse click on the green arrow or on the red X to confirm the change).When this append any code doing ole with excel hang waiting for Excel reply.
>
>I must find how to tell to Excel to apply the change before doing anything else. I am searching in activecell, activeworkbooks ............oExcel.DisplayAlerts = .F.
This should avoid (ignore) Excel prompts. I use it when saving, to avoid Excel's prompt "do you want to save xxx?" It would probably do what you want.