Stack Overflow
Stack Overflow

Questions tagged [excel-web-query]

Excel Web Query, Internet Inquiry (IQY) - A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web.

A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with static parameters send a query without any input by the user; queries with dynamic parameters prompt you for input. Regardless of the type of parameters in the query, the requested information is pulled from an Internet or intranet site, and the results are placed in a worksheet.

113 questions
0
votes
1 answer

Why is Web Query not highlighting my table in Microsoft Excel 2010?

I am looking to use Excel's Web Query feature to give users access to constantly changing datasets. Why not ODBC straight to the database? Well, there are several databases on several servers that I'm dealing with. To avoid granting users varying…
dangowans
  • 2,263
  • 3
  • 25
  • 40
0
votes
0 answers

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost

I have a sharepoint document library. On exporting to excel i get the message "the table contains a string that is too long for excel to display. if you edit the long value some data might be lost". Why is this message being displayed, and how to…
TheCoder
  • 181
  • 4
  • 12
0
votes
0 answers

How to Excel web query this web site when I cannot input parameter in the URL

The website I am trying to Excel web query is (http://www.hkexnews.hk/sdw/search/search_sdw.asp). Where I need to input stock code (E.g. 1237) and press "search" button to get the search result. However parameter is not shown in the link. Is there…
Louis Ng
  • 13
  • 2
0
votes
1 answer

Using For loop through string +

First, I want to say that this is my first attempt at building vba code. I am trying to extract data from the web using a web query .Add(Connection,Destination,sql). What I want my code to do is to loop through the string 'str' containing stock…
drap
  • 3
  • 1
0
votes
1 answer

Webquery in a new Excel workbook application

I think the problem here is with reference to new workbook which is opened in the new Excel Application. This is the part of the code were is the error. If to change nb.ActiveSheet.QueryTables.Add to ActiveSheet.QueryTables.Add everything works (but…
Samuel
  • 83
  • 2
  • 14
0
votes
1 answer

Webqueries multiple tables into one column

I've made a code that downloads data using webquery from website (several pages) in a loop. Everything is great but instead of downloading data in the same column ("B2") if to set ActiveSheet.QueryTables(1) it creates one table starting in B2 but…
Samuel
  • 83
  • 2
  • 14
0
votes
1 answer

VBA - On.refresh() function

I want to execute a bunch of functions, every time a refresh happens on the web query i have on the same excel file. The web query is fetching data every 10 mins and a pivot sits on the data. How can i write a code in order to refresh the pivot…
Tom
  • 135
  • 1
  • 5
  • 14
0
votes
1 answer

Login to Yahoo via Query in a Macro. cookie passing?

I have a table that i need to import from yahoo that I want to run as a macro. Macro Recorder does this fine, however when i set up the query (when recording) I have to first login and then select the table. The query works within the macro as long…
kamelkid2
  • 524
  • 3
  • 14
  • 29
0
votes
1 answer

Excel web query providing the incorrect table

I am using excel's web query feature for the first time. The site I am using it on is here. I put a check mark next to the table TTM Yield Load etc.. I click import, but a different table than the one I selected is produced in excel. It's one far…
Matt Cremeens
  • 4,951
  • 7
  • 38
  • 67
0
votes
0 answers

VBA Multiple Web Queries Hangs Even After Clearing Cache

Couldn't find the solution anywhere. I'm download stock data for about 500 stocks using a Web Query. It will eventually hang before it downloads the entire stock list and I will have to the End Process. It works if I break the list into 3 separate…
user3301921
  • 1
0
votes
1 answer

Excel VBA Web Query Behavior Questions

I am working on a small excel project where I have a user form. The user form has a combo box that has a list of company names retrieved from column (A) in an excel worksheet (This works as expected). The form has a text box, that depending on the…
cquadrini
  • 769
  • 2
  • 12
  • 25
0
votes
2 answers

Trouble with Web Query in Excel

I´m having some trouble with two different web queries in Excel. 1) Website: http://www.danielsoper.com/statcalc3/calc.aspx?id=44 Trouble: I can´t seem to obtain the result value of the query. Basically, I´m inputting the parameters in an excel…
PedroRochedo
  • 1
0
votes
1 answer

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but that just brings up the whole stock quote across…
Vedant Chandra
  • 342
  • 2
  • 3
  • 15
0
votes
2 answers

Web Query VBA Refresh

If I have a web query connection established, what's the best way to update the URL and refresh the connection with VBA? Here is basically what I want to do: Sub RefreshWebQuery() Dim request As String request = 'some url constructed by…
nightTrevors
  • 639
  • 4
  • 11
  • 24
0
votes
2 answers

Relative reference for Macros

I am new to macros, and to recording them. I created a webquery with a parameter that it edits a part of the query based on a cell I select. I now have to run this web query 800+ times. So I recorded myself doing it with the "Use relative…
namer98
  • 1
  • 1
1 2 3 4 5 6
7
8