querytables

  1. Y

    Debugging errors for macro on for other users

    I have created a Macro as follows to create a web query and loop through the alphabet to append the data of multiple queries into a worksheet. The macro is connected to a button on one of the worksheets in my Workbook. Issue: I can run it on my computer (Trust Center settings set to Macros -...
  2. T

    How do I prevent a web query inserting a new column for the Destination?

    I have coded a web query as follows: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;https://query2.finance.yahoo.com/v7/finance/options/" & UnderlyingSymbol & "?date=" & ExpiryEpoch & "", _ Destination:=Range("OptionQuote")) .BackgroundQuery = True .TablesOnlyFromHTML =...
  3. M

    Cannot open URL using QueryTable code

    I am trying to download a CSV file through a QueryTable in VBA. I don't know why this is occurring because I can download the CSV file just fine when I use a browser. The path to the CSV file is: https://www.tsp.gov/InvestmentFunds/FundPerformance/index.html?whichButton=CSV The VBA code to...
  4. J

    Importing Multiple RecordSets into QueryTables on a single sheet

    Hello, I have written some VBA code (below) that sets up an external data connection in a workbook, queries a stored SQL procedure on an external server and imports the resulting recordset into a QueryTable. However, I have a stored procedure saved on a server that contains two select...
  5. S

    QueryTables URL generating a Google search "Site:" gets "Google Instant is Unavailable" message.

    Hi, I'm running a QueryTables.Add(Connection:="URL".. that generates a Google site: search. It works fine on my laptop computer, generating the results I expect (the indexed URLs on a site). However, on my desktop, which is a faster machine, I am only generating this Google message...
  6. G

    Sharepoint QueryTables command missing a Linked Column

    Hello, I am using VBA to call for an export of the SharePoint list I am using into an Excel workbook. The code, seen below, works nearly perfectly but runs into one snag. There is one column in my SharePoint view that is Linked to a different SharePoint List. This column is one of the...
  7. W

    ZIP files make "Strict Parse Error" in Excel VBA QueryTables - I think

    Environment: Excel 2010 in Windows 7 Question: Can QueryTables gracefully handle encountering a .zip file when expecting .txt? We have a database of text-based information logs from a large number of machines. The log files are stored as the same file name, but located in a folder path that...
  8. E

    delete connection

    The following code gives me the "Run-time error '9': Subscript out of range" error on the last line, but only the first time it is run in a blank workbook. mypath = [windows network path]<WINDOWS Path Network> myfile = [text file name]<FILENAME extention without> With...
  9. E

    Web query - how to ignore "<" character in a table?

    Hi, I have a VBA program that pulls messages out of another system (that posts messages on our intranet within HTML code) and processes them further in an Excel program. We have used this for several months with everything working great, until we figured out that Excel was ignoring text within...
  10. A

    Troubleshooting Querytables

    I've built an Excel VBA Application using QueryTables that connects to an internal server. Users must be logged in through VPN to connect. Sometimes, however, even if a user is logged into VPN, excel sometimes doesn't realize it. I know this is the case bc if I hit the same URI in a web...
  11. S

    Delete Named Ranges and reset Excel's memory of previous ranges

    I'm trying to build a workbook that builds a query table based on a user's entry of a parameter and have this change when they enter a new parameter. I've built the macro so that it's structured like so 1) clear any existing data 2) get data from report 3) copy and transpose it to another...
  12. E

    Does querytables.add -require- activesheet

    My workbook will have between 20 and 200 sheets (situation dependent) with querytables added to each sheet. With that quantity I am hoping to not have to make each sheet active to get a query added. However, my testing so far shows it works every time the current query is referring to the...
  13. A

    Dynamic website as a target for QueryTable

    I am trying to create a dynamic QueryTable connection. The site I am using displays a table of data as well as some filters. Everytime you change the filter, the webpage reloads with different data. I need to import these various data tables into Excel. How can I automate this via VBA? I...
  14. H

    What is wrong with this syntax?

    Hey guys. Why dosnt this syntax import data from the file I choose? Sub Makro1() Dim filename As String filename = Application.GetOpenFilename("Text Files (*.tsp),*.tsp", , "Please selec text file...") With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;filename", _...
  15. F

    Excel VBA: Setting time limit to a Web Query

    Hi! Recently I created a VBA Macro which automatically adds web query tables into a worksheet. I have about 100+ of them in a worksheet and it loops by itself once I run the macro. And the problem is that once in a while it just paused at one of the query for a long time (Statusbar shows...

Some videos you may like

This Week's Hot Topics

Top