Share via

Runtime error at ".Refresh BackgroundQuery:=False"

Anonymous
2016-04-19T15:47:04+00:00

I have a macro in a workbook on our company network that contains four separate ODBC queries.  I have run the macro successfully on my computer and others have, as well.  On one computer, though, it is giving a Runtime Error 1004.  When I click DEBUG, I'm taken to the following line in the code...

.Refresh BackgroundQuery:=False

Is there a solution to this??

Why does it work on some terminals and not on hers??

Thanks for your help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-08T11:35:09+00:00

    For the benefit of anyone else who may have had this same question, we found that the terminal in question did not have the latest ODBC Driver installed.  We updated the driver and solved the problem.

    Good day, everyone!!

    James

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments