Run time Error 1004

[Ammai]

My Excel Macro queries a DB2 database and populates the results(report) in excel sheet.The macro works fine for majority of report requests, but for some reports it gives the error no : 1004 and crashes without proceeding.It also says unable to set orientation property to the pivot field class.I couldn't debug as when i step into the macro it crashes.If anyone can shed some light into thsi it would be great.
Thanx
Ammai

 

[Guest_imported]

According to what Microsoft says, you maybe need to install Text to Speech feature. The error handler can be used as a temporary solution.
For example

ErrorHandler:
If Err.Number = 1004 Then
Resume Next
End If

or

ErrorHandler:
If Err.Number = 1004 Then
MsgBox "Unable to process your request."
End If

 

[Ammai]

I'll try this out.Any other suggestions?

Thanks
Ammai

 

[Guest_imported]

Can you post the exact description of the error message? It can be:
Run-time error '1004': Application-defined or object-defined error
or
Run time error 1004: Add method of <collection> class failed (this one can cause Excel to crash)
or
Run-time error '1004':
Unable to set the Focus property of the DialogSheet class
... and many more.

 

[Ammai]

Hi,
It says:
RUN TIME ERROR 1004
UNABLE TO SET THE ORIENTATION PROPERTY OF THE PIVOT FIELD CLASS and then crashes.

Thanx
Ammai