Macro Error

  • Thread starter Thread starter Bryan Holland
  • Start date Start date
B

Bryan Holland

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Run-time error '1004' 5
Run-time error '1004' at "Application.Calculate" 2
Excel Macro error 5
Paste chart images macro fails 10
Do not undesratnd the error when calling EXcel macro from .vbs script 2
Run-time Error '-2147417848 (80010108)' 1
Run-time Error '1004': Selection is too large. 0
how do i setup a macro which is initiated by a button? 1

Back
Top