Querytable

B

Ben.c

Hi
There is on my computer a macro which is using a querytable. And this querytable is now disabled. when I start it, it's giving to me the message "General ODBC Eroor". Could you explain me where I can found the querytable to see if something have changed (I don't know where is the program of the querytable) and what is this error
Thank
Benjamin
 
T

Tom Ogilvy

for each sh in ActiveWorkbook.worksheets
for each qt in sh.QueryTables
Application.Goto qt.ResultRange, True
selection.Interior.ColorIndex = 5
msgbox "hit enter to continue"
Next
Next

--
Regards,
Tom Ogilvy



Ben.c said:
Hi,
There is on my computer a macro which is using a querytable. And this
Click to expand...
querytable is now disabled. when I start it, it's giving to me the message
"General ODBC Eroor". Could you explain me where I can found the querytable
to see if something have changed (I don't know where is the program of the
querytable) and what is this error ?
 
B

Ben.c

hi Tom,
thanks for the answer but I think I didn't say what I want correctly because I know which are the cells that the querytable change. What I need is to see the program of the querytable...
If you have any idea, you are welcome
thanks. Best regards
Benjamin
 
T

Tom Ogilvy

You can only see the settings. select in the querytable region and do
Data=>Get External Data and select Edit Query

or right click anywhere in the query results and choose edit query.

--
Regards,
Tom Ogilvy

Ben.c said:
hi Tom,
thanks for the answer but I think I didn't say what I want correctly
Click to expand...
because I know which are the cells that the querytable change. What I need
is to see the program of the querytable...
 
Top