Hi Craig,

oExcelApp = CreateObject("Excel.Application")

WITH oExcelApp

    .Visible = .T.

    * ----- This will stop user intervention
    .Interactive = .F.

    * ----- Report Processing

    * ----- This will allow user intervention
    .Interactive = .T.

ENDWITH

RELEASE oExcelApp

Hope this helps,
Gavin...

>I am automating excel to create some report outputs and get an error if users attempt to close excel before it has finished.
>
>Is there some way to prevent users from closing the application till I am ready?
>
>I could simply make excel invisible until complete, but sales team think watching the fields populate is a "feature" .
>
>TIA,