VBA and Web. How to import web data using VBA

  • Published on Feb 17, 2017
  • VBA and Web. How to import web data using VBA
    This tutorial will show you how to sync web tables, data, contents using VBA. Set up connections, refresh existing connection etc.
    Have fun!
    Download code here: vbaa2z.blogspot.in/2017/02/vba-and-web-how-to-import-web-data.html
    Please subscribe and have fun!
    Contact us @ VbaA2z@yahoo.com
    Please mentioned in Subject RU-clip.com/VbaA2z
    Please feel free to post your questions or topics you want to cover on Discussion tab.
  • Science & TechnologyScience & Technology

Comments • 17

  • Vishnu Lal Raveendran Nair

    Dear team, thanks for this video. You really make our lives so easier.
    I'm an ardent follower of your channel and have learned a lot by just tuning into your channel.
    I see that the video on automating web works wonderfully well. I have tried many websites and found it working without any hassles. However the same code isn't working when I try to implement in my office. I mean these codes don't work for internal websites of my organization. I'm getting automation error(unspecified error)/ disconnection error (the object invoked has disconnected from its clients) when I try to run the same code.
    Is there a special reason or if there is any other way round?

    • Lyle912
      Lyle912 Year ago

      Have you found a fix for this error? I have the same issue, code working fine at home, but on work I get the The object invoked has disconnected from its clients error

  • Tim Patterson
    Tim Patterson Month ago +1

    excel 365 looks very different, but concept is a geed starting point.

  • Brilliant Techno Tech
    Brilliant Techno Tech 3 months ago +1

    Bhai muje Fno stocks ka option chain ka data automatically import karna hai kaise kar

  • Senthil
    Senthil 5 months ago +1

    Nice video.I have a query. Is there any way to retrieve the historical prices of any stock from NSE INDIA website by changing the cells which has the COMPANY NAME, FROM DATE and TO DATE in Excel with VBA, which fetches the DATE, OPEN, HIGH, LOW, CLOSE & VOLUME for the company for dates that we have selected ?
    Thanks in advance.

    • VBA A2Z
      VBA A2Z  5 months ago

      That depends if the page allows users to access historical data. If yes, we can use HTML library / api to achieve what you need.

  • Cool Krish
    Cool Krish 6 months ago

    Hi team,
    I just want to download a dynamic data which is auto updating for every hour in a day. I used to download through link. It directs me to csv file directly. Can you suggest any hardcode works for that instead of recording.awaiting your response

  • Edward Reyes
    Edward Reyes 8 months ago

    could you show me how did you do the youtube subs and views part? i'm trying to do something similar and couldn't have get it done yet.

  • Yogesh Suryavanshi
    Yogesh Suryavanshi 8 months ago

    Hi, thanks for sharing this. Through this method can we extract and store pdf files?
    Thanks in advance :)

  • Video YuTube
    Video YuTube 10 months ago


  • Bhavna Thawani
    Bhavna Thawani 10 months ago


  • Pedie Pamai
    Pedie Pamai Year ago


  • Pedie Pamai
    Pedie Pamai Year ago


  • d Akho
    d Akho Year ago +1

    Very simple to follow and informative. Thanks

    • VBA A2Z
      VBA A2Z  Year ago

      Thanks! Subscribe and enjoy!

  • pemz tangkhul
    pemz tangkhul 2 years ago

    nice demo

  • M4dd5efc Ace gamer
    M4dd5efc Ace gamer 2 years ago +1

    subbed bro thanks