• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

WEB Grabs Data Extraction from the net with Macros

N

NJ786

New Member
Hi,


Just wondering if any one done this before, i am not good with macros or vb, but was thinking if could have a general sheet with a macro that could grab the data from a given URL.


Have seen another Topic (http://chandoo.org/forums/topic/macros-web-query-huge-headache-can-anyone-help-me)but that only pulls one line of information.


My Requirements:


Given any URL, the code should be able to pull any data that is available in a tabular format with proper headings.


I know i can try the Web Query in Excel, but the issue is that we have different types of data and the web query at times fails to pull the data of pulls out junk characters.


also at times you have tables that need to select a date from a drop down and then click on go button to get the data and on other places you have a simple table but have to select the day/date from their headings for the days of the week.


Hence one code to rule them all.


Greatly Appreciate if any one can help....


NJ


attached URL links for ref.


https://docs.google.com/open?id=0B5jCQSsK1WJ9WHFITU1GUmMwdzA
 
Hi, NJ786!

As far as I know nothing general can be done, it depends on how is the data stored in each website.

Regards!
 
Hi


So this means that each web page needs to be configured seperately to grab data.


In cases where the WEB Query gives an error and no data can be grabbed, what can be done?


Regards


NJ
 
Hi, NJ786!

First statement, yes. Second statement, you can do nothing but retry, and if persists then check if source has changed it structure or availability.

Regards!
 
You must log in or register to reply here.
Back
Top