Excel VBA Pull Data From A Website

[MMinecrafTT]

@DontFretBrett i have already tryed that but if i let my program let type faster than 0.2 sec it start opening data from my comp....

plaz help

[DontFretBrett]

@MMinecrafTT starts opening data from your computer???

[MMinecrafTT]

@MMinecrafTT yea

i use vb 2011

and if i do this

time1.tick

sendkeys.send("#")

and i set the timer speed < 0.2 then sometimes when sendkeys.send = enter

it starts opening data...

[MMinecrafTT]

@DontFretBrett it is a site and you can try logging in as much as you want, and it doesnt say something like : wait 2 min

is that what you mean with protection or do you mean the database??

[DontFretBrett]

@MMinecrafTT - If that's the case you could write a bot to try a list of passwords, or you could just try every combination of letters and characters, like if the PW is greater than 3 characters then you could literally try every combination. aaaa, aaab, aaac, aaad, etc. Might take a few days, but if it doesn't prevent you from brute force that could be one way

[MMinecrafTT]

can you get a password from a site 2 ? :D

[DontFretBrett]

@MMinecrafTT Depends on how well it's protected

[pursarth]

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!

[vitpereira]

better use pyton for this purpose

[SuperStatistician]

This is great, thanks for sharing.

[niggszo]

Awesome tutorial

can you please email me the code for this?

thanks

[hkwae100]

couldn't post code here

[hkwae100]

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

[hamy72]

Great tutorial........ I hope you put more such Excel VBA material that crosses over other such MS office applications.... very informative.

[lctrinh88]

Can you pull data from pdf files?

[madman1391]

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?

[DontFretBrett]

@madman1391 can you message me the code?

[chwwll]

Great Tutorial, watched again and again, helped me a lot for pulling data. One should go for the whole video.

[iamravikc]

Excellent

[lukster79]

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.

[DontFretBrett]

@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

[Fairyavanna]

would it work with Chrome? (I am working with Excel for Mac 2011 and I don't have Internet Explorer on my Mac)

Thks!

[vivi122908]

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

[DontFretBrett]

@vivi122908 Thanks! What do you mean by determine my codes? Like the names of the webpage elements?