I have a vertical application (Rockwell RSView) that has a button to run a
daily report. When we run the report we get an error. It is reported as:
Microsoft Visual Basic, Run Time Error 1004, SQL Syntax Error. If you click
on debug, the following line is highlighted.
.Refresh BackgroundQuery:=False

If I close out of that, another error is displayed: Microsoft Visual Basic,
Run-time Error '440':, Automation Error. If I click on debug, the following
line is highlighted:
objExcel.Application.Run "Monroe_Mondata.xls!CurrentReport"

I have little experience with troubleshooting macro's. Any advice would be
appreciated.

Thanks.