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.