DontFretBrett
DontFretBrett
  • 22
  • 1 310 774
Excel VBA - Easily parse XML data from a file or website using XML Maps
This tutorial shows you how to use Excel's built in XMP Maps feature to easily import XML data from a file or website
Google geocode api used in the video:
maps.googleapis.com/maps/api/geocode/xml?address=95838&sensor=false
zhlédnutí: 95 741

Video

Send Email From Excel Using VBA & Gmail
zhlédnutí 73KPřed 11 lety
This tutorial shows you how to use CDO to send an email from within Excel! Code here: brettdotnet.wordpress.com/2013/06/06/send-a-gmail-email-from-excel-using-cdo/
Excel VBA - Get Stock Quotes from Yahoo Finance API
zhlédnutí 491KPřed 11 lety
FreeTutorials *Edit this no longer works due to Yahoo abruptly decommissioning their stock API. Still worth a watch if you want to learn how to how to interact with an API in excel and some string manipulation techniques In this tutorial, I show you how to use Yahoo's finance API to download real time stock quote information. This tutorial utilizes a for loop, string manipulation /...
Excel VBA Yahtzee
zhlédnutí 4,8KPřed 11 lety
Whipped this up for fun since I'm a Yahtzee fan. It'd be really easy to cheat but it'd be fairly easy to add additional code to prevent people from manually editing the dice or inputting scores.Workbook here: dl.dropbox.com/u/1062712/Yahtzee/Yahtzee.xlsm brettdotnet.posterous.com/excel-vba-yahtzee Since posterous closed: brettdotnet.wordpress.com/
Excel VBA Tower of Hanoi / Lucas Tower
zhlédnutí 3,3KPřed 11 lety
Excel workbook and source available here: dl.dropboxusercontent.com/u/1062712/Hanoi/Hanoi Tower 10 Discs.xlsm I watched the movie Rise of the Planet of the Apes and there is a scene where they have the ape solving a puzzle called Lucas' Tower (aka Towers of Hanoi). I was curious to try the puzzle and downloaded a few iPhone apps. I loved the game so much I decided to recreate it in Excel. It su...
Excel VBA Using A Web Service with XMLHTTP - Weather Forecast HD
zhlédnutí 29KPřed 12 lety
(HD Version) This tutorial shows how to use Excel VBA to get information from a web service using XMLHTTP. Code can be found here: brettdotnet.posterous.com/excel-vba-using-a-web-service-with-xmlhttp-we Since posterous closed: brettdotnet.wordpress.com/
Excel VBA Using A Web Service with XMLHTTP - Weather Forecast
zhlédnutí 43KPřed 12 lety
This tutorial shows how to use Excel VBA to get information from a web service using XMLHTTP. Code can be found here: brettdotnet.posterous.com/excel-vba-using-a-web-service-with-xmlhttp-we Since posterous closed: brettdotnet.wordpress.com/
It's a wonderful shuffle
zhlédnutí 267Před 12 lety
Everyday we're wonderfully shufflin
Switchfoot singer climbs into the stands
zhlédnutí 100Před 12 lety
Switchfoot singer climbs into the stands during we were meant to live
Original Song
zhlédnutí 560Před 13 lety
I was going through my old external hard drive and found this vid I made, not my favorite song but whatevs
Excel VBA Pull Data From A Website
zhlédnutí 542KPřed 13 lety
The website has changed since I originally made this video. The state appears to have been removed but you can still get the city and county at least. Change the code from what I say in the video to this: Dim sDD as string sDD = Trim(Doc.getElementsByTagName("dd")(0).innerText) sDD = split(sDD,VbNewLine)(0) Range("city").Value = Split(sDD,", ")(0) Range("county").Value = Split(sDD,", ")(1) A tu...
Birch Aquarium La Jolla California
zhlédnutí 109Před 14 lety
Little iPhone video compilation I took at the Birch Aquarium in La Jolla California
Automate a Google and Bing Search VB.Net WebBrowser Control
zhlédnutí 15KPřed 14 lety
A VB.Net tutorial showing you how to automate a google or bing search in VB.Net using the WebBrowser control. If you have any questions or if you would like a video tutorial on a subject please let me know! Sorry if I moved to fast in this video! brettville Since Posterous closed: brettdotnet.wordpress.com/
my unfinished songs vid 3 of 3
zhlédnutí 522Před 14 lety
my unfinished songs vid 3 of 3
my unfinished songs vid 2 of 3
zhlédnutí 346Před 14 lety
my unfinished songs vid 2 of 3
my unfinished songs vid 1 of 3
zhlédnutí 490Před 14 lety
my unfinished songs vid 1 of 3
Brett Sanders - Be Alive
zhlédnutí 143Před 15 lety
Brett Sanders - Be Alive
Boombox
zhlédnutí 57Před 15 lety
Boombox
Instrumental: Quantum Soup
zhlédnutí 557Před 15 lety
Instrumental: Quantum Soup
The Pink Life
zhlédnutí 385Před 15 lety
The Pink Life
Me on my Martin DCME
zhlédnutí 10KPřed 16 lety
Me on my Martin DCME

Komentáře

  • @Friedena
    @Friedena Před 7 měsíci

    Great tutorial. How do we handle Client authorization like for example, a .jks file / password when it is secured.

  • @josephdaquila2479
    @josephdaquila2479 Před rokem

    I'm not sure the internet controls reference still exists

  • @myheehawfun
    @myheehawfun Před rokem

    Send me this file.

  • @666saturation7
    @666saturation7 Před rokem

    how does he highlight the key words ?

  • @andreiturcan9692
    @andreiturcan9692 Před rokem

    Hi, this is a great video. Can you advise how to extract date+time from next: <time from="2022-12-16T18:00:00" to="2022-12-16T21:00:00">

  • @Darioq57
    @Darioq57 Před rokem

    Is that actually VBA? This sub will not go passed the first line without an error, starting with Dim Mail as New Mail.

  • @redhaakhund1271
    @redhaakhund1271 Před rokem

    amazing, how to use with MS Edge

  • @hasanmougharbel8030

    Hey there, god bless your efforts. I am still learning about sql by my own and having today a simple question. I learned that Processes (also known as “procedures”) may take values and give out parameters. Are processes opposite of a function? Is there any related functions used to execute a process? Thanks..

  • @mannix34
    @mannix34 Před 2 lety

    Awesome!

  • @JasonH550
    @JasonH550 Před 2 lety

    Dang, the file no longer exists.

  • @mgzsev3969
    @mgzsev3969 Před 2 lety

    Any plans to do any more videos? You taught me so much.

  • @manim1840
    @manim1840 Před 2 lety

    Excellent sir, this vedio... same like that i need for delivery status from the website, How i will get the use consignment no. to get the status...

  • @dgb5820
    @dgb5820 Před 2 lety

    Wow this is awesome

  • @henrikkock
    @henrikkock Před 2 lety

    Excellent tutorial. Just what I was looking for. I like your zooming. Only improvement is to stop using stupid Fahrenheit and use Celsius instead;-)

  • @neetalalchandani4400
    @neetalalchandani4400 Před 3 lety

    Thankyou

  • @hillariusanom3353
    @hillariusanom3353 Před 3 lety

    W.Cells(i + 2, 2).Value = Replace(Split(Split(sLine, Chr(34) & "," & Chr(34))(1), Chr(34) & ",")(0), Chr(34), "") cant you fix this?

  • @antemilovac4964
    @antemilovac4964 Před 3 lety

    what year is the guitar from and what is the model of that guitar?

  • @yelfieka2558
    @yelfieka2558 Před 3 lety

    May i get file source code sir?? Please

  • @lucaslemosfranco2413
    @lucaslemosfranco2413 Před 3 lety

    Excellent!!

  • @jaedonbigbrain8700
    @jaedonbigbrain8700 Před 3 lety

    I did something similar but it doesn't work there's a mistake that I don't find out could you help me please ? Just watching my code

  • @veyselyaprak
    @veyselyaprak Před 3 lety

    Hi Brett, i am very new in that kind of stuff. I am trying to pull down information whether one email address is verified or not via the website tools.verifyemailaddress.io/ ... With your tutorial i cant do this, because it is not possible to come to a result by using ...?EmailAdress=... in the url. Do you have a solution for me for this?

  • @twinspierre-louis2346

    Good day. I tried completing this task, but I kept getting the type mismatch error message for the line IE.navigate. Can this error be corrected? Please advise.

  • @leszekdrozdz6559
    @leszekdrozdz6559 Před 3 lety

    We can't find the page you're looking for.

  • @alialmatos268
    @alialmatos268 Před 3 lety

    Hello Good day Thanks for the video , I catered the code but I received message object required , how to solve ?

  • @Khyrid
    @Khyrid Před 3 lety

    camelCaps ftw

  • @Mostafafahim2000
    @Mostafafahim2000 Před 3 lety

    perfect jop

  • @easyearning6682
    @easyearning6682 Před 3 lety

    this the awesome video

  • @ahrorkuldashev9603
    @ahrorkuldashev9603 Před 3 lety

    Great video! Could you also create a similar video about downloading files from websites. Say, you enter a date range and download a excel file with transactions within the given date range.

  • @PaulSmith-rp2mw
    @PaulSmith-rp2mw Před 3 lety

    Hey bro. I have seen some guys scrape data and show price vs volume levels allowing us to gauge how high or low a stock will go with respect to the volume at those levels. Can you show how to do that?

  • @user-jw1if1lg4u
    @user-jw1if1lg4u Před 3 lety

    Английский знаю очень плохо, но автор смог объяснить даже мне )

  • @osareafallire
    @osareafallire Před 3 lety

    I spent all Friday afternoon trying to figure out how to do this and apparently forgot that I watched this video at some point. Soooooooooooo perfect!!

  • @abuabou7679
    @abuabou7679 Před 3 lety

    when right click on the insect element in the search , dnt find the name of the search instead place holder in website screener.com

  • @djmadmike23
    @djmadmike23 Před 3 lety

    Can you do this with randomly adding or searching for individual stocks with an API?

  • @manismaithani8375
    @manismaithani8375 Před 4 lety

    Can i get marksheets from website in to excel worksheet according to roll numbers. Plese help me

  • @tthinker9897
    @tthinker9897 Před 4 lety

    Found a very easy work around. Create an Excel stock spreadsheet with the same list of stocks you're watching or invested in. Create the identical Watchlist in Yahoo Finance. Export the Yahoo watchlist to a download file and open it. It will not be in Excel format, but that's ok. Copy the column of current prices from the Yahoo Quotes spreadsheet into your Excel spreadsheet and paste Links. Current prices will populate. Just did this, so don't know if I can automate the updates or if I must do it manually each time. Very new to this, so any help welcome.

  • @tthinker9897
    @tthinker9897 Před 4 lety

    This no longer works? Just noticed that after inserting Developer tab, Refresh Button, and then did not see why you opened the code window. Starting to search for explanation of that, I noticed it doesn't work! I'm frustrated - short of paying for a stock data access suite to enable real time export of prices (which makes so little sense with the little $ I have in right now) the only option I can find is to manually update the prices on my 30+- stocks by hand. And I have bad hand tremors so every keystroke involves 2 corrections - again, frustrating.

  • @drs10301
    @drs10301 Před 4 lety

    Dear Sir, I need to select multiple or all options from the list box and proceed for next options. please help me with the code for the below list box html data. <select name="selectedCampaign" id="campaign" class="campaign" style="width:200px" multiple="multiple" onchange="getAgents();"> <option value="AAAAAAAA">AAAAAAAA</option> <option value="BBBBBBB">BBBBBBB</option> <option value="CCCC">CCCC</option> <option value="DDDDD">DDDDD</option> <option value="EEEEE">EEEEE</option> <option value="FFFFF">FFFFF</option> <option value="GGG">GGG</option> <option value="HHHHH">HHHHH</option> <option value="IIIIII">IIIIII</option> <option value="JJJJJ">JJJJJ</option> <option value="KKK">KKK</option> <option value="WELCOME">WELCOME</option> </select>

  • @majherndon2166
    @majherndon2166 Před 4 lety

    Is this still a thing Brett? Went to the gummy-stuff URL and I’m not seeing the cheat sheet on your tutorial?

  • @richstevenson1
    @richstevenson1 Před 4 lety

    Was great that you showed the end result up front. Thank you!

  • @yelfieka2558
    @yelfieka2558 Před 4 lety

    sorry sir... may you upload file source code

  • @-simon-3442
    @-simon-3442 Před 4 lety

    Sweet thank you so much bro

  • @lindiribeiro1130
    @lindiribeiro1130 Před 4 lety

    Great, Aqui do Brasil excelente tutorial.

  • @ignacioa3698
    @ignacioa3698 Před 4 lety

    I know you can pull data like say, income statements rows and columns for financial analysis. How bout for pulling that same data when the data is in an imbedded pdf forms where you cannot open up the actual pdf that’s posted on the webpage, but all you can do is scroll left and right within the pdf. That format is popular in financial sites currently.

  • @mittapalli1990
    @mittapalli1990 Před 4 lety

    Run time error object 424 coming. In line Set Config = Mail.Configuration, what to do?

  • @corporatelifecoach
    @corporatelifecoach Před 4 lety

    Please help me with a web portal that needs user name and password and the data in the portal needs to be scanned like every 2 hours can u help please

  • @beastgaming8501
    @beastgaming8501 Před 4 lety

    now xl has direct stock option

  • @americanswan
    @americanswan Před 4 lety

    Does this work with the new Edge browser?

  • @paulthayer4915
    @paulthayer4915 Před 4 lety

    DontFretBrett, I am getting an error about COM+ not being installed. Is that an Excel add on that I need in order for this to work?

  • @naucifacio
    @naucifacio Před 4 lety

    does anyone know how to pull that data with the "id" instead of the "name" of the element?

  • @hanshima_
    @hanshima_ Před 4 lety

    Not possible anymore, google made the SMTP server available only for G Suite customers. But thanks for the code.