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

Excel 2007 will not reformat an xml web query which has a datetime field

I have a web service which returns XML which looks like: 9 Bob 2011-04-21T11:34:34.234234234-04:00 2011-04-21…
bpeikes
  • 3,495
  • 9
  • 42
  • 80
0
votes
1 answer

How do I update an Excel Workbook Web Query Connection String using VBA?

I'm trying to modify a Web Query connection string using VBA, however all of the answers I've found online give solutions that require a QueryTable, but my workbook has no QueryTable for the reasons that this post explains. What I have is a list…
Dracius
  • 79
  • 10
0
votes
1 answer

Web query connection does not create table in excel

I have the below external…
dali1985
  • 3,263
  • 13
  • 49
  • 68
0
votes
0 answers

Excel Dynamic Web Query (Simple Problem!)

I'm trying to import a simple HTML table from a website into EXCEL on an iMac I wrote a text file saved as…
nowifi6952
  • 1
  • 1
0
votes
0 answers

Webquery vba select only second row

Dears contributors, I would like to automatically download content from a website and place it to excel. I have already created a code with a prompt box to extract the content from the web. What i would like to do now, without success after many…
Oliviertwist
  • 1
  • 1
0
votes
0 answers

Web query refresh error

I have 3 workbook web queries on a single data sheet , and I have a dropdown object with a list of months in the year (1-12). My idea for the automation was to have the query formula update based on the user selection of the dropdown value and…
Mike Mirabelli
  • 402
  • 3
  • 16
0
votes
1 answer

getting Data from a page that doesn't show table

I'm trying to get live Data from a website into my Excel spreadsheets.The only problem is when I go to the webpage via Get Data in Excel, the table is not recognizable. I'm only able to import the whole page, and even then it does not get the Data I…
Issy the kid
  • 15
  • 4
0
votes
1 answer

Excel web query append to table

I have just worked out how to get data into a table using excel web query. However, every time the data is refreshed it overwrites the last update over the top. Can I use web query to load data into a table by appending to the existing table on each…
Mike Parson
  • 1
  • 1
0
votes
2 answers

Dynamics webquery from url in cells

I searched the internet, but I could not find anywhere a dynamic query from links in cells. In excel i have webquery which generate this data: I have data in excel Sheet("CustomReport"): SalesOrder Value1 Value2 Value3 Links 1 …
Seva Arve
  • 65
  • 8
0
votes
1 answer

Excel: import from web

For some reason, the web import fails with this website! What I am looking for is the table that is generated after choosing the needed filter. https://support.microsoft.com/en-us/lifecycle/search?alpha=windows%2010 The required table appears in the…
EKA
  • 23
  • 5
0
votes
0 answers

Excel Web Query Parameters Error

I'm having troubles adding parameters to a Web Query that reads currency rates. Parameter: date format that updates daily (YEARMONTHDAY) in Cell ("A1") - As ["datums"] URL: http://www.bank.lv/vk/ecb.xml?date=["datums"] Error - in URL: Error - in…
Nikolajs
  • 325
  • 1
  • 3
  • 17
0
votes
0 answers

Excel Web Query Parameters

I have URL that has an available list of exchange rates and I want to add a parameter that takes a date format from Cell("A1") and places it in the URL. I've tried setting it up as the following Address = http://www.bank.lv/vk/ecb.xml?date=["date"],…
Nikolajs
  • 325
  • 1
  • 3
  • 17
0
votes
1 answer

Excel edit web query import button is disabled

Hi am trying to edit the web query in excel. It is calling a sql procedure It is allowing me to edit the query and when I click on the GO button I can see the changes(column headers) as well in the popup. But the problem is import button is…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
0
votes
1 answer

VBA QueryTables loops class reference

What I am trying to do is grab data form mutable URLs, at the same time using cells A1 to A10 as the last string of text on the URLs QueryTables. Example Cell A1= B0006SH4PA URL or QueryTables would changed in reference to cells…
user8035099
  • 11
  • 3
0
votes
0 answers

Excel WebQuery malformed after Office update (Version 1705)

The excel workbook (populated by webqueries using VBA) , which , I have been using for more than a year now has suddenly lost many formatting and some data. Upon debugging, I find that when the HTML has a tag, the data is not saved to Excel…
Arvind S
  • 87
  • 1
  • 7
1 2 3 4
5
6 7 8