Very informative video Sir! Is there any chance to cover the Get/Post request for login in a server by XML or HttpReq in VBA as on RUclips this content is not that common or very well explained. Thank you and good job.
A lot of it is research and expanding on different concepts I already had under my belt. However, I do have a few books on my website that I recommend. Here is the link to the page: sigma-coding.com/book-recommendations/ For the most part if you're trying to do Python and VBA in the same task then there is only one book that covers that topic. With VBA, I was always surprised how hard it was to find books that went beyond the Excel Object model. There are maybe 2 books I can think of off the top of my head that go beyond Excel VBA and even when they do it's very limited.
I should be able to put my API key in the User variable section of Environment Variables and then use VBA.Environ("name-of-API-key") and it should return the value correct? I tried doing this but it comes back as an empty string. My variable name matches Google-Places-API-Key but like I said it returns an empty sting. I also tried adding $. VBA.ENVIRON$("Google-Places-API-Key"). Maybe this is not an option?
Hi ! Thank you for the video. I have tried to load a longer query but I see VBA imported only partially the XML. I would highly apreciate an advice on this issue. thank you !
Great video. Please help me about how to connect my vba to web service of SSS. I cannot access the web service even thou I have the tokenID given by the admin.
Great video! Looking forward to connecting to the Adobe applications. Also, that IE workaround you mentioned in the recent webscraping from vba videos? I'd like to see that - don't even have IE on my computer! Thank you! Keep 'em coming!
Yeah I'm still working on the IE workaround, it might require the download of a 3rd party software so I'm trying to see if there are any alternatives before doing that.
I am getting one error in my Excel macro and the error is: 'XML document must have a top level element". Any one know why am getting this error please help
In 2023 still fantastic video, first video explaining XML tree to excel process - thanks so much
The Only Practical Video I have found on API requests and Response handling in VBA Excel....Thanks A Lot
I'm glad you found it useful!
Very informative video Sir! Is there any chance to cover the Get/Post request for login in a server by XML or HttpReq in VBA as on RUclips this content is not that common or very well explained. Thank you and good job.
Thank you so much for making this. Extremely helpful
Congrats, please make a video for POST request.
can u help me in creating xml api with my excel VBA. everything i followed but it throws error
Thank you!
I need to load the query along with loop, but the loop won't let the query be loaded, could you help me?
great video! where did you learn all that stuff about vba, xml and python? is there any book you would recommend?
A lot of it is research and expanding on different concepts I already had under my belt. However, I do have a few books on my website that I recommend. Here is the link to the page: sigma-coding.com/book-recommendations/
For the most part if you're trying to do Python and VBA in the same task then there is only one book that covers that topic. With VBA, I was always surprised how hard it was to find books that went beyond the Excel Object model. There are maybe 2 books I can think of off the top of my head that go beyond Excel VBA and even when they do it's very limited.
@@SigmaCoding link doesn't work
Thank you! Subbed!
Amazing. Thank you.
I should be able to put my API key in the User variable section of Environment Variables and then use VBA.Environ("name-of-API-key") and it should return the value correct? I tried doing this but it comes back as an empty string. My variable name matches Google-Places-API-Key but like I said it returns an empty sting. I also tried adding $. VBA.ENVIRON$("Google-Places-API-Key"). Maybe this is not an option?
Hi ! Thank you for the video. I have tried to load a longer query but I see VBA imported only partially the XML. I would highly apreciate an advice on this issue. thank you !
What font it is?
Great Video. Thank you.
I want to learn to automate a lot of my tasks at work. What do you recommend? Python or VBA. Can I do more things using Python? What about Javascript?
Thank you thank you thank you!
Great video. Please help me about how to connect my vba to web service of SSS. I cannot access the web service even thou I have the tokenID given by the admin.
where i can find my own api key?
or i have create it by something?
API Keys have to be created by yourself, so in this case since we are using google places API you would need to get one from there.
Great video! Looking forward to connecting to the Adobe applications. Also, that IE workaround you mentioned in the recent webscraping from vba videos? I'd like to see that - don't even have IE on my computer! Thank you! Keep 'em coming!
Yeah I'm still working on the IE workaround, it might require the download of a 3rd party software so I'm trying to see if there are any alternatives before doing that.
@@SigmaCoding Thank you!
I am getting one error in my Excel macro and the error is: 'XML document must have a top level element". Any one know why am getting this error please help
Are you using it with the Google API?
Ativa legenda para português, vai ajudar os brasileiros.