Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

Import External Web Query

Hello Experts,

If I look on such title, I found many solution, but I feel everyone has their own criteria and tables. I am trying to Import External Data with New Web Query from BSE Market Watch.
I just want to get Sectoral table in specific cells of a worksheet. Could anyone help me please?
0
Shums
Asked:
Shums
  • 2
1 Solution
 
Elton PascuaCommented:
Here's something to get you started. One sheet does the query while the other does a refresh of the query and extracts the Sectoral table.

Edit: Looks like EE didn't want XLSB files. Had to change to XLSM (won't attach).
web-query.xlsm
0
 
ShumsAsst. Financial ControllerAuthor Commented:
Wow,

Perfect....Can we have multiple webquery from 5 different URL in source sheet & offset in sectoral?
0
 
Elton PascuaCommented:
I think that's possible although I have not tried. I actually recorded the macro when I added the webquery and was just refreshing it on another part of the code.

You can do the same with 4 more queries.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now