• 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.

Data extraction from websites

B

Booga

New Member
Hello all,

I have been manually collecting different data sets from different websites over the past 2 years. After 2 years of data collection, I am wondering if there is a way that VBA can be automated to collect the data from online sources and have them arraigned in a specific order. The collected data is amalgamation of price forecasts mixed with historical actuals. I have already managed to secure an Add-in for one of the online sources to have the data downloaded, but still need to manually have it re-arraigned due to website constrains.

your kind feedback would be much appreciated.
 
Since you have not provided any details, I will provide you with a general response on how I would do this. I would use Power Query to extract the web data and then use the PQ editor to mash up the data to a format you need. If you provide sample data, we can get more specific.
 
You must log in or register to reply here.
Back
Top