It would help if you could post the text of the error message...

--
Tim Williams
Palo Alto, CA


"Panos Stavroulis." wrote in message
...
Hi,

I am trying fix an error message from the database coming into excel after
you press a button, ie run a macro. It produces some syntax error on the
database and it fails.

I can see that the button is assigned to a macro, then I can see all macros
and I've searched through them for opening database connections, ie ADO
calls. I can't see anything connecting to a database. Also profiler on SQL
Server doesn't show anything (maybe the request goes to the wrong server?) I
can't see any external data queries either.

What else is in an excel file that can make calls to a DBMS? Thanks.

Panos.