tags:

views:

209

answers:

1

when i set Excel apllications displayalert propery to true this exception is fired... why?

+1  A: 

Is the property browser suspended? If so, this might help: HRESULT 800ac472 from set operations in Excel


One suggestion is to put your call inside a try block inside a loop, and keep trying the call until it succeeds. It might look something like this:

retry = True

Do
    Try
        'Put your call here.
        retry = False
    Catch ex As Exception
        'Need to try again,
        'If this isn't the 0x800ac472 exception it should be re-thrown,
        'Use Sleep(50) to reduce the number of retries,
        'Use Exit Do or re-throw the exception to give up.
    End Try
While retry

I don't write in VB myself, so apologies for any mistakes.

richj
i read that previously but i didn't get what to do?
Kiran
One suggestion is to put your call inside a try block inside a loop, and keep trying the call until it succeeds.
richj
@richj Its working fineThnx!
Kiran