Multiple Queries - Getting error

I recorded the following macro to pull an excel tables as a query on multiple tabs. I get errors randomly from week to week on some of these sections. Thanks so much in advance!...

.ListObject.DisplayName = "Table_Query_from_Excel_Files"

------------------------------------------------------------------
THE ERROR IS 1004 GENERAL ODBC ERROR
------------------------------------------------------------------


I have about 8 of them and about 4 give me the error.

Please Login or Register  to view this content.