Querytable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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 ?
 
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 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...
 
Back
Top