Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: gbrendemuehl
- Order by date
-
Running Excel Web Query & Importing to Access - Revisted
Found it. I thought that when I saved the query, the file name and the query name would be the same. I found where the name is set in the spreadsheet, changed it and now it works. Thanks for your help. Gary- gbrendemuehl
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Running Excel Web Query & Importing to Access - Revisted
That was the first thing I checked. I found the query file "USPSTracking.iqy in c:\Documents...\Application Data\Microsoft\Queries. And it is definitely on Sheet1. It's probably something simple, but I'm not seeing it.- gbrendemuehl
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Running Excel Web Query & Importing to Access - Revisted
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...- gbrendemuehl
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
