I am getting an error implementing the solution presented in the previous thread titled "Running Excel Web Query & Importing to Access". The error is "Error 9 - Subscript out of range" on the statement "Set objQueryTable = objWorkSheet.QueryTables(strQueryTable)"
Here is my code:
Private Sub...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.