Import data with Webquery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I need to import data from web pages but I need only data from certain
cells, not the whole table. Excel lets me select tables only. Can anyone
suggest a solution for selecting individual cells as source?

Thanks.

Kolos
 
Import to the "Data" sheet and use a macro to copy the desired info to your
"destination" sheet.

sheets("data").range("a2:x4").copy sheets("destination").range("a2")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

webquery needs to import to row, not column 1
Posting data from worksheet to webquery ?? 2
single web query without adding to defined names 1
webquery with login first 7
Problem with webquery in VBA 1
How to retrieve data from web? 4
Importing several web pages with macro/VBA? 9
Check URL exists in Webquery 4

Back
Top