![DontFretBrett](/img/default-banner.jpg)
- 22
- 1 310 774
DontFretBrett
Registrace 3. 01. 2007
...
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
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/
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/
Great tutorial. How do we handle Client authorization like for example, a .jks file / password when it is secured.
I'm not sure the internet controls reference still exists
Send me this file.
how does he highlight the key words ?
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">
Is that actually VBA? This sub will not go passed the first line without an error, starting with Dim Mail as New Mail.
amazing, how to use with MS Edge
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..
Awesome!
Dang, the file no longer exists.
Any plans to do any more videos? You taught me so much.
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...
Wow this is awesome
Excellent tutorial. Just what I was looking for. I like your zooming. Only improvement is to stop using stupid Fahrenheit and use Celsius instead;-)
Thankyou
W.Cells(i + 2, 2).Value = Replace(Split(Split(sLine, Chr(34) & "," & Chr(34))(1), Chr(34) & ",")(0), Chr(34), "") cant you fix this?
what year is the guitar from and what is the model of that guitar?
May i get file source code sir?? Please
Excellent!!
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
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?
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.
We can't find the page you're looking for.
Hello Good day Thanks for the video , I catered the code but I received message object required , how to solve ?
camelCaps ftw
perfect jop
this the awesome video
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.
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?
Английский знаю очень плохо, но автор смог объяснить даже мне )
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!!
when right click on the insect element in the search , dnt find the name of the search instead place holder in website screener.com
Can you do this with randomly adding or searching for individual stocks with an API?
Can i get marksheets from website in to excel worksheet according to roll numbers. Plese help me
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.
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.
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>
Is this still a thing Brett? Went to the gummy-stuff URL and I’m not seeing the cheat sheet on your tutorial?
Was great that you showed the end result up front. Thank you!
sorry sir... may you upload file source code
Sweet thank you so much bro
Great, Aqui do Brasil excelente tutorial.
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.
Run time error object 424 coming. In line Set Config = Mail.Configuration, what to do?
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
now xl has direct stock option
Does this work with the new Edge browser?
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?
does anyone know how to pull that data with the "id" instead of the "name" of the element?
Not possible anymore, google made the SMTP server available only for G Suite customers. But thanks for the code.