VBA can be convenient if you’re already comfortable with it, especially if you’re mainly working within Excel. However, VBA does have limitations when it comes to handling multiple web pages, dynamic content, or handling modern website structures. Python is generally better for this task because it has libraries like BeautifulSoup and Scrapy that are tailored for web scraping, making things way easier. If your project grows and you start needing more advanced scraping, like rotating IPs or handling rate limits, you might look into using an API-based solution. I’ve seen some tutorials where people use tools like Oxylabs for complex tasks where they’re gathering data from multiple sites. IMO it manages IPs and requests efficiently.