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.

The actual error is really irrelevant. It's a database error message,
something like table v_holdings does not exist. It's the type of message you
will get when you query a database. I am SQL SErver expert so I know the
database layer very well. It's the excel I have the problem, somewhere is
querying the database but not via ADO DAO calls. This is what I am trying to
figure out.

Thank you.

"Tim Williams" wrote:

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.