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.

Bryan,
Sounds like something you ought to be asking Rockwell tech support.
Regards,
Jim Cone
San Francisco, CA

"Bryan Holland" wrote in message
...
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.