Hi

No this is not the problem. The message I received is not from Excel. The system display a box saying that the program is busy. In this small box I have three button (my XP is french but I will try to translate le label for you). First button "Swith to ..." second button "Retry" the last button "Cancel".

To explain what I did in Excel. Opend a worksheet, type something in any cell and don't do anything else (don't do enter and don't click anywhere else. Take note that as soon you type something in a cell there is two icon in the top of the worksheet that appears (an red X and a green arrow) and if you put your mouse pointer over you will see a tool tip ("cancel" for the x and "enter" for the arrow) Excel is waiting for you to confirm what you put on this cell. There is three way to confirm. Doing enter key or click the x or the arrow. Until that Excel will not respond to any ole command.

There must be a property that we can change or a method to tell to excel that we want to comfirm the entry.

Take note that when I am doing OLE I open Excel and I am opening a worksheet using OLE with Excel but after this is a user who will complet part of the worsheet so if the user type something but don't do enter or don't click the X or arrow I am not able to do OLE anymore with Excel.

Thanks


>>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.