Excel VBA Pull Data From A Website
Loading...
Uploader Comments (DontFretBrett)
All Comments (17)
-
Hi Brett, thanks for posting this video. I am able to fire up IE and the MsgBox. However, I am having trouble with the getElementsByName part. Every time I run it, I get a "Run-time error '91': Object variable or With block variable not set" error. What am I missing? Thanks again for the video - learnt a lot!
-
better use pyton for this purpose
-
This is great, thanks for sharing.
-
Awesome tutorial
can you please email me the code for this?
thanks
-
couldn't post code here
-
Hi, absolutely fabulous video, exactly what i needed right now. but i can't get the data from another web. Please help me out a bit. the code is like
-
Great tutorial........ I hope you put more such Excel VBA material that crosses over other such MS office applications.... very informative.
-
Can you pull data from pdf files?
6:35
Web scraping the easy wayby sequentum7,494 views- 5:42
Export data directly into Excel from a web page in IE7by bytebodger17,156 views
- 6:28
Web Scraping, Screen Scraping, Web Data Mining, Data Extractorby vickyrathee20057,004 views
- 1:00
Extract Data From Web Macroby tristanbaluyut3,347 views
- 16:18
VBA Programming for Excel part1 of 10by jeanpaulruche16,487 views
- 3:44
Excel VBA - Create a Digital Clockby jiejenn2,814 views
- 2:00
Creating a sales invoice - Serviceby DeltaTechComputer38,001 views
- 9:45
Excel VBA Range/Cell referenceby peterdcasey3,273 views
- 1:56
Get City, County, and State from Zip Codesby bjhughesfs1,921 views
- 4:18
Extract Data from Web Pages into XML, Excel (CSV), RSSby YummyVegetables1,058 views
- 4:13
How to transfer data from internet into Excelby jksynergyworks15,488 views
- 2:40
Retrieving Web Service Data into Excel (Part 1 of 2)by SpreadsheetWEB3,446 views
- 8:08
Easy Web Extract - Extracting web data from Google product (new)by mrcanhnv7,869 views
- 2:06
Using Excel 2007 to grab live data from the web x264by AperioITA5,761 views
- 6:57
Get started with Excel VBAby TechEdGuru1,240 views
- 2:22
How can we extract data from the Web continuously?by questpond18,219 views
- 6:04
A Digital Clock in Excelby EngineeringFun8,909 views
- 3:19
Looking For A Good Custom Icon? - Icon-Generator.netby nunokaka851,089 views
- 5:42
MS Excel :How To Import Data From Web to Excel (English)by excelmadeasy599 views
- 1:01
VBA -- Download Historical Stock Prices from Yahoo Finance into Excelby JoshuaRadcliffe441 views
Im Trying to do this however i get an error that says "Argument not optional" At the line when i try to navigate to my website. Any ideas?
madman1391 7 months ago
@madman1391 can you message me the code?
DontFretBrett 7 months ago
Great tutorial. Could you run this on multiple zip code lines though? Sorry perhaps it's a basic question but I have no experience in visual basic.
lukster79 11 months ago
@lukster79 Yeah definitely. There's actually a faster way to look up information from websites without using a browser window. I'll make another video on that soon hopefully
DontFretBrett 11 months ago
hello my name is vivian, ur video is really helpful. i just have one question how do u determine ur codes? pls let me know
vivi122908 1 year ago
@vivi122908 Thanks! What do you mean by determine my codes? Like the names of the webpage elements?
DontFretBrett 1 year ago