Error Microsoft Excel OLE

[Former Member]

Hi All

I am trying to execute the report in analyzer, in the variable selection screen the selection value are not displaying the process is still running , i am not able to see the values for input. i am getting the message like " Microsoft Office excel is waiting for another application to complete the OLE action".

I don´t understand why.

Thanks

[Former Member]

Hi Ben,

The error message you are receiving means that an Excel macro is waiting for another macro to finish in order to proceed. It is an informational message so you understand why the system is slower than expected.

The solution is on the Microsoft side, see BOJ Note 1201513.

From the MSDN link below, you will see a description of the Display

Alerts Property:

http://msdn.microsoft.com/en-us/library/aa194195(office.10).aspx

DisplayAlerts Property

wdAlertsNone No alerts or message boxes are displayed. If a macro encounters a message box, the default value is chosen and the macro continues.

The Note suggests changing the "Application.DisplayAlerts = False" to "Application.DisplayAlerts = wdAlertsNone"

Best regards,

Edward John

[Former Member]

Thanks. It is necessary open the macros in Excel.