Жыл бұрын
Жыл бұрын
Пікірлер
@deninsrmic4165 28 күн бұрын
Great tutorial, thanks, it would be great to have more examples on how to work on xml files via VBA. My task was to search in large xml file for data matching in Excel and then extracting specific values from different node and transferring them to Excel on specific rows. I had to read a lot to get through xml file via VBA, as very little is covered on this topic! Many thanks for valuable information, but as I said it could be of great value to see more examples how to parse xml and learn for instance use of namespace in VBA like rootnode.SelectSingleNode("ns:" & queryString) or how to use methods xmlDoc.setProperty "SelectionLanguage", "XPath"; xmlDoc.setProperty "SelectionNamespaces", "xmlns:ns='…. All the best
@HypocrisyLaidBare Ай бұрын
no mention of how to get the search query of multiple words in one window in chrome though, every multi words search returns a separate chrome window for each word in the input box example: search for "domesticated animals" in the input box (query) and chrome returns two open tabs one for "domesticated" and a second for "animals", and not one chrome tab for "domesticated animals" which is a totally different series of websites and information to the two strings when searched separately. "domesticated animals" is a term, and "domesticated" & "animals" are both words when used singularly. as a result they mean different thing when linked together than the sum of their individual meanings when separate. My point is that the VBA code is returning a faulty result for a searched "term" (string of words), and returns the singular of each word. Another example would be "weather maps UK" the desired result would be a chrome result showing a map that covers the UK and is related to weather. However, the VBA code above would return separate chrome tabs for each of the definitions of what the words "map", "UK", and "weather" mean. (Completely useless information) All of which are unconnected to what is required of the search query
@Mindful_Explorer 28 күн бұрын
Oh, that's easy! To ensure that a multiword search query is treated as a single phrase simply replace spaces with the + symbol in the input box. 😊
@borreguito1986 2 ай бұрын
How i can search multiple data in chrome?
@Luke-ew9mk 2 ай бұрын
Is it possible to rewrite this for Google Chrome?
@Mindful_Explorer Ай бұрын
Yes, but you would need to use Selenium along with ChromeDriver, and would need to update the ChromeDriver everytime a new version of Chrome browser comes out. ChromeDriver needs to be compatible with the version of Google Chrome you are using. Chrome updates frequently, sometimes as often as every six weeks, and these updates can include changes that might break compatibility with older versions of ChromeDriver. Basically, it can be a pain in the neck. :)
@Luke-ew9mk Ай бұрын
@@Mindful_Explorerthanks a lot for the explanation!!! :D
@troyajohnson26 2 ай бұрын
I've modified your code to match my xml data, but when I run the code, it highlights yellow the first item in the loop. How does it know to look for my specific child nodes? My xml is much larger and has many tables associated with it, but I only need the data from one particular section.
@Mindful_Explorer 2 ай бұрын
It sounds like the code is highlighting because it's trying to loop through all child nodes, but it needs to be more specific for your larger XML. To focus on one section, you'll want to target the exact node you're interested in. Here's an example: Dim xmlDoc As Object Set xmlDoc = CreateObject("MSXML2.DOMDocument") xmlDoc.Load (filePath) ' Adjust "SectionName" to match the part of your XML you need Dim sectionNode As Object Set sectionNode = xmlDoc.SelectSingleNode("//SectionName") If Not sectionNode Is Nothing Then Dim childNode As Object For Each childNode In sectionNode.ChildNodes Debug.Print childNode.Text Next childNode Else MsgBox "Section not found" End If Make sure to check your XML structure to find the right node. If your XML is more complex, adjust the SelectSingleNode with the correct path.
@troyajohnson26 10 күн бұрын
@@Mindful_Explorer Thanks! Still can't get the code to parse the data. my xml has much more data. It's a series of tables that include stuff like: <table plsname="Construction Staking Report" tagname="construction_staking_report" ncols="89" nrows="114" units="0" version="14" titledetail="">. So trying to mirror yours is very confusing for me lol
@DLVideo94 3 ай бұрын
Thanks, I wanted to do this for a very long time but it's not working with the new Outlook app.
@lion123145678 4 ай бұрын
please share me XML file in the video
@sachinacharya9123 5 ай бұрын
Great explanation sir... Could it be possible you to share the code or the script.? It will be very helpful... Thank You...
@lovet7239 5 ай бұрын
Huge thanks to you! It was very useful for me. I have understood how to create XML parser i need!
@BlkSkl006 9 ай бұрын
I enjoyed the video and look forward to using this in a variety of projects. Unfortunately, even just with the first example I get an error at the line "Set doc = IE.document". It looks like I've typed everything accurately. Any ideas? Or could you send me the file so I can see one that works? Thanks!
@Mindful_Explorer 9 ай бұрын
Hi there, Thank you for reaching out and sharing your experience. I'm glad you enjoyed the video and are eager to apply what you've learned! The error you're encountering at Set doc = IE.document could be due to a few different factors: Ensure you've followed the step to set up the necessary references in your VBA environment as highlighted in the video at the 2:49 mark. Missing references can often lead to unexpected errors. Double-check that your Excel workbook contains a 'Sheet2' with a value in cell A2, as the code attempts to navigate to a Wikipedia page based on this cell's value. If you've confirmed the above and are still facing issues, could you please share the exact error message you're encountering? While sending you the working file might seem like a quick fix, it's essential to ensure your environment is correctly set up to run these scripts, as differences in settings or versions can affect the outcome. Let's start with these suggestions, and I'm here to assist you further based on the feedback you provide. Looking forward to helping you get this resolved!
@JurijSmirnov-t3z 9 ай бұрын
That was helpful in my excel vba project, thanks.
@Mindful_Explorer 9 ай бұрын
Glad it helped!
@LiegeoisCecile 9 ай бұрын
Thank you very much for this tutorial. You explain everything so clearly.
@CableyCarole 10 ай бұрын
Nice one
@MelissaGazzini 10 ай бұрын
Can you make tutorial on how to use google chrome for data scraping?
@saramanoni 10 ай бұрын
This has got to be the best beginner's course I've had
@saramanoni 10 ай бұрын
@RenataCattolico 10 ай бұрын
Thanks for uploading this tutorial
@dorotapozarlik3918 10 ай бұрын
Easy to understand, thanks
@dorotapozarlik3918 10 ай бұрын
Is it possible to make the button more interactive?
@dorotapozarlik3918 10 ай бұрын
Can I undo changes made by VBA code?
@AntonioPaganelli-e9c 10 ай бұрын
Exactly what i was looking for
@MebarekLamia 10 ай бұрын
Helpful
@MebarekLamia 10 ай бұрын
Nice
@alitalalhaidar6488 10 ай бұрын
Do you mean it has to work only with Internet Explorer? which means for example not with Microsoft Edge or any other web browser?
@Mindful_Explorer 10 ай бұрын
In this case, yes, only with Internet Explorer.
@JuanManuel-f9v 11 ай бұрын
Nice one!
@SusanneHallpape 11 ай бұрын
helpful tutorial, thanks
@DustinBurch-j4k 11 ай бұрын
Thanks
@latoyamcdowell7473 Жыл бұрын
Promo-SM 🙌
@alitalalhaidar6488 Жыл бұрын
Next need: Optimum prompt in Google Bard that profits the best from the Automated Google Scholar Data extraction. In other words, the needed video should give a technical prompt that forces Google Bard (or ChatGPT 4, or ...) to give the answer not from their own general knowledge, but only based on a search through Google Scholar. The prompt should allow me to specify details inside Google Scholar, such as year of publication. In this way, any time I have an idea about a new scientific publication, I use this prompt, that profits from the power of Excel, to fill in information inside specific cells, each of them asking me to answer some given questions, then Google Bard gives me the best it can of this publication
@alitalalhaidar6488 Жыл бұрын
You are just great. Desperately needed. Thank you
@alitalalhaidar6488 Жыл бұрын
And another video on "How to automate Semantic Scholar data extraction into Excel using VBA"
@alitalalhaidar6488 Жыл бұрын
We need a video on "How to automate Google Scholar data extraction into Excel using VBA"
@Mindful_Explorer Жыл бұрын
Check out our video #33: kzbin.info/www/bejne/fonLlYShgZloick
@MichelinaLopiano Жыл бұрын
Easy to follow.
@MichelinaLopiano Жыл бұрын
Brilliant series.
@vessentials-y1g Жыл бұрын
Great!
@vessentials-y1g Жыл бұрын
Good tutorial. Thanks.
@EmilyJanowski-f6x Жыл бұрын
Fantastic
@MaryAndre-x8j Жыл бұрын
This tutorial has been a great help!
@StefanKlemp-q2q Жыл бұрын
Fantastic tutorial!
@Сам-в1я 3 жыл бұрын
Can you share please the VBA code. Thank you.
@vladmarius6627 3 жыл бұрын
Good job . Is any way to achieving this ? Thanks
@ozlekayadele3956 4 жыл бұрын
will you share the link to download the excel VBA template ?
@YS-lv4tu 4 жыл бұрын
Thanks, that's brilliant. Can you share this ?
@Jasper-fs8mk 4 жыл бұрын
Awesome. Can you share the template? Thanks!
@llwayneio 4 жыл бұрын
Is this available to download? No idea how to use excel VBA.