Web Automation - How to import web data using VBA

Friendly tutorials on VBA Web Automation Videos to Extract any Web table, take Webpage offline to extract contents, download files from Web Page, Find and control web objects, fill web forms and more...

Please like, share and comment to improve channel algorithm

You can now support by buying any of the Projects or Source Code.

📌What to watch next:

#VbaA2z

[vishnulalraveendrannair]

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?

[dakho]

Very simple to follow and informative. Thanks

[ayemyint]

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

[gokulakrishnansubramaniam]

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

Thanks,
Gokul

[senthil]

Hi,
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.
Senthil

[saurabhsonkar]

How did you do for the count of YouTube subscriber in which the data was getting updated in the next row, I want to do the similar thing with other data, please help me out

[Yogesh.Suryavanshi]

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

[edwarddejesusreyes]

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.

[loi]

Hey sir can you make tutorial on how to get strike value and OI from option chain of *Angel Broking site please

[_karan-egtm]

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

[GokhanAcikgoz-fd]

merhaba hocam
youtube videolarınızı izledim ve zor bir konuda size danışmak istedim.
İnternette bulduğumuz markaların web sitelerini ve e-posta adreslerini Excel'e atmak istiyoruz. Yani sol satırda şirket veya marka adı, hemen yanında otomatik google'dan alınan web sitesi ve e-posta.
Yeni markalar buldukça onları excel dosyasına ekleyeceğiz ve kod çalıştıkça web sitelerini ve e-postalarını bulmaya devam edecek.
Bu konuda ücretsiz veya ücretli yardımcı olursanız çok sevinirim.
İşinin tadını çıkar.

[smganesh]

Good, how to get auto login using macro while this data query if a webpage asks username and password?