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
0 answers

Import data from multiple pages of a website into excel?

I want to auto fetch data from various web pages of a single website . The link is the same but just the last number changes like this : http://reo-agents.net/agents/1 the link remains the same just the end number changes till 953157. As there are…
Mohit Sharma
  • 1
  • 3
0
votes
1 answer

If I do not open an Excel file with web query will it still update automatically or not?

I have created a web query on a spreadsheet, will it update automatically if I do not open it? And does anyone know if Excel on Mac have automatic 1 minute refresh option or not?
user2413421
  • 113
  • 1
  • 2
  • 8
0
votes
1 answer

Access Excel webquery file in C#

I have created a webquery in excel which fetches data from the webpage in Excel file. Is there anyway i can access the same webquery in C#. I hope it makes sense. Need some valuable suggestions with the coding.
waris kantroo
  • 83
  • 3
  • 21
0
votes
2 answers

Need to pull data from a website...web query? macro?

I have a list of every DOT # (Dept. of Trans.) in the country. I want to find out insurance effective date for each one of these companies. If you go to http://li-public.fmcsa.dot.gov --> "continue" --> then from the dropdown select "carrier…
Patrick
  • 5
  • 1
  • 3
-1
votes
1 answer

How to handle a Time Out?

I am running an Excel power query in a loop. The query runs. For a reason related to the internet (I am not in a fiber covered area) the query fails to load the data, returning a time out error. Given that is possible the entire loop cycle has not…
Marco_sbt
  • 309
  • 1
  • 12
-1
votes
1 answer

excel vba pulling income statement/balance sheet/cash flow via web query

I was able to import financial statements into excel using web query on the link "http://www.advfn.com/stock-market/NASDAQ/NVDA/financials?btn=annual_reports&mode=company_data". I recorded the import process into a macro and patched up the vba code…
Jason Huang
  • 1
  • 1
  • 1
-1
votes
1 answer

After data refresh sort column A alphabetically

I am having a little issue with my excel spreadsheet, I am hoping someone can help. I have Names starting in Cell=A7 that go to A177. All the other information are in Columns (B:H). Ideally I would like to run the code after I hit a Data Refresh.…
DomsDad18
  • 1
  • 1
  • 2
-2
votes
1 answer

Excel Web Query Show Full HTML Code

Does anyone have a way that I can use a web query (or another automated VBA way) to import the full html code of a page into an excel page? I need just about everything from to but don't mind if there is a solution that requires the…
user2803146
  • 137
  • 3
  • 14
1 2 3 4 5 6 7
8