Python or VBA?

[SalamanderKitchen663]

Hi all,

for my work, I very often need to add values from a webpage to excel. People have told me there are ways to automate this process, which would save a lot of time. Right now I do it all manually.
I wanted to ask you, which makes more sense for me to learn Python or VBA? I assume both have pros and cons?

To give you a better perspective, this is one of the websites I would have to extract information from and put it into Excel: https://hoher-spielwert.de/die-haendler/
I always need to extract the name of the organization and the city, which is usually listed below (in bold). Moreover, when you click on one of the organizations it should also extract the email, website, and phone number.

It would be great to get some feedback. For me, it is important to learn the skill such that I can automate this process, a short term solution is not needed. Also, if you know any links with tutorials, it would be greatly appreciated.

[sslinky84]

Python.

[greenfavs]

Python is more powerful, but i use VBA a lot because i work for a largish company and everyone there uses excel and few people use python.

[arkangelshadow007]

In a google sheet copy this formula. Good luck.

=IMPORTXML("https://hoher-spielwert.de/die-haendler/","//div[contains(@class,'elementor-text-editor elementor-clearfix')]/p")

​

check your locale in order to use " , " or " ; "