Querytable
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 |
Querytable
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 |
Querytable
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 |
Querytable
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 |
Querytable
Nice !!!! Merci beaucoup...
Best regards Benjamin |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com