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

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" wrote in message
...
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 ?
Thanks
Benjamin

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

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" wrote in message
...
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

Nice !!!! Merci beaucoup...
Best regards
Benjamin