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
2009-12-23 13:27:01
i read that previously but i didn't get what to do?
Kiran
2009-12-23 13:29:37
One suggestion is to put your call inside a try block inside a loop, and keep trying the call until it succeeds.
richj
2009-12-23 13:40:50
@richj Its working fineThnx!
Kiran
2009-12-23 14:00:18