Hey vagabond. I learned just through trial and error, googling stuff. One small step at a time. Been programming with VB for over 15 years. I'm sure there are some VBA books out there. I have contemplated doing a full VBA series to take one from absolute excel beginner to full on VBA professional
@razandy
12 жыл бұрын
Its OK Brett. Thanks for your reply but i have sorted it and now my eBay Excel system is working like a dream all thanks to your Vids, Thanks Again :-)
@ricardolopes9960
9 жыл бұрын
Excellent Tutorial! How should I enter a username and password? The website I am trying to reach, requires this information. Thanks for supporting a lot of people.
@mariellamarrero7773
9 жыл бұрын
Brett, How do we add reporting for multiple cities? What do we have to type in after "next weather" and before "End Sub"? I know we need the URL for the next city, and I will re-name the field descriptions to have the information flow correctly, just not sure how to get the button command to also bring in the information for the new city. Any thoughts?
@andreiturcan9692
Жыл бұрын
Hi, this is a great video. Can you advise how to extract date+time from next:
@vagabond197979
12 жыл бұрын
Brett, thank you for these cool vids. I just started recently getting into using excel to collect information from the internet. Can you tell me where you learned how to do this? Is there a book that would help me? I have found a bunch of examples on the internet but I would just like a bit more formal explanation. Btw, I'm interested not only in using XML but also the InternetExplorer object (and other) with early and late binding. Thanks.
@Myrslokstok
6 жыл бұрын
I am loading down an excel file from an web page where you log in and you take out the file as a report. Sometimes it works and some times it doesnt, I get a 404 error or a 200 and it works. It is a bit more code, but I do not get why it works half of the times.
@alikalkandelen8344
6 жыл бұрын
Hey Fret, How different would the code be if you received a JSON object instead of an xml? Do you have any videos you can link that would show that difference?
@jaedonbigbrain8700
3 жыл бұрын
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
@jaymurallon
9 жыл бұрын
Hi brett, We have the same code but I'm stuck with Run-time Error '91' - Object variable or With block variable not set, at this specific line: wShape.Fill.UserPicture Weather.SelectNodes("weatherIconUrl").Item(0).Text Please help, thank you.
@deepaksinha8010
11 жыл бұрын
Hi Bret I want to know how to fetch flight schedule in xml format using webservice in vba would you pls put on you youtube it might be much helpfull for beginner
@razandy
12 жыл бұрын
Hi Brett. I came up with some code based on your tutorial thank u. How can I make the below XML work which includes Parent and Child Nodes within one record? How would I switch the getElementsByTagName from SaleRecord then to SalesStatus to extract ShipDate. I can not extract the ShipDate when getElementsByTagName SaleRecord is selected. (SaleRecord)(Title)Widget(/Title)(QTY)10(/QTY)(SaleStatus)(ShipDate)2012-01-16(/ShipDate)(/SalesStatus)(/SaleRecord) Thanks in Advance
@ubaleamit
10 жыл бұрын
Hi brett, how i can download temperature from accuweather without using any XMLHTTP. if you have any idea pls help...
@razandy
12 жыл бұрын
Hi Brett Is there any chance you could show an example (if you are able to) show how one would get this working on a web page using HTML? You now if I wanted it to work in a specific area of my webpage. Thanks in advance
@nickfraser1084
9 жыл бұрын
So I've been stuck on this for quite a while, always at the first responseText bit . Each time I run this i get a run-time error stating "Method 'open' of object 'IXMLHTTPRequest' failed Any help?
@MachielMastenbroek
9 жыл бұрын
Nick Fraser It means that the URL is not working any more, I updated the VBA code including a new URL. See my post on: brettdotnet.wordpress.com/2012/02/11/excel-vba-using-a-web-service-with-xmlhttp-we/comment-page-1/
@mpredolim
8 жыл бұрын
Excellent! Thanks a lot.
@deepaksinha8010
11 жыл бұрын
Hi razandy why dont you put on switch the getElementsByTagName from SaleRecord then to SalesStatus to extract ShipDate application on youtube in vba bz I am vba learner too
@deepaksinha8010
11 жыл бұрын
Hi bret uhave wondefull video but try to put some advance video in vba like automating reportng in vba
@deepaksinha8010
11 жыл бұрын
Hi razandy may i see this application vba webservice which you made based on weather forecasting m talking about shipdate salesrecord in vba
@janezklun
7 жыл бұрын
The beste tutorial!!! Is it possible to get some new ones, thank you
@deepaksinha8010
11 жыл бұрын
Hi razandy can you send me your workbook which has given vba webservice code for SaleRecord)(Title)Widget(/Title)(QTY)10(/QTY)(SaleStatus)(ShipDate)2012-01-16(/ShipDate)(/SalesStatus)(/SaleRecord) let me know how did u write the code
@neeravpatel85
6 жыл бұрын
Awesome.. Thanks..
@pietermlouw
7 жыл бұрын
How would I code this to take readings every hour and actually store the data?
@DontFretBrett
7 жыл бұрын
Pieter Louw you could do a loop and save to a database or something but there's not an easy way to do asynchronous operations in excel. I've seen it done using directx.. people have made games in excel using it. So you could do a loop with an hour pause but your excel UI will be frozen / non interactive
@pietermlouw
7 жыл бұрын
How would you go about doing this? Would you rather create a Chrome extension and import to an excel sheet?
@CornerMeetJZ
12 жыл бұрын
that's awesome. if i ONLY need today's weather information, such as Feb. 16, 2012, how can i change the code below: For Each Weather In Resp.getElementsByTagName("weather") i = i + 1 Range("Date").Cells(1, i).Value = Weather.SelectNodes("date")(0).Text Next Weather 'cause the codes above will get the final day weather information, say Feb. 17, 2012 Thanks for your time~
Пікірлер: 31