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

Fun thoughts

J

Jamie

New Member
Not sure how to post this as it could relate to excel, but I don't plan on it. I am curious to see however if my fellow excel nerds are as curious as I:

I am interested to know if anyone has had any luck with web scraping? I started in excel, then branched out to other programs and I feel like open source would be the way to go. I have not found a particular program specifically I like however (My favorite with potential I'd say was importio). I also do not want to have to manually code. Lastly, inconsistencies among sites prove to be a challenge. Thoughts, ideas, stories to share? Ready, go!
 
If website has table(s) that I want, I use Data ribbon->"From Web"->New Web Query dialogue.

But mostly, I tend not to use data from external websites and primarily work with company sites that I have database connection rights to (MySQL, MS SQL, Access or SharePoint list).
 

Web scraping often requires to code !
I reproduce the same request of source website
with ActiveX like MSXML2.XMLHttp, WinHttpRequest, …
Sometimes I have no choice except to pilot IE …
You can see both samples in VBA Macros forum threads.

With less skills coding, see selenium-vba or Seleniumbasic tool …
​
 
You must log in or register to reply here.
Back
Top