Question: VBA or Python program?

[lumineers01]

I'm thinking of a way to do things faster and I find VBA and Python programs a great ease. However I am still in a slowwwww and long way of learning both. So I don't have a clear idea which is better to use in this process that I am thinking of:

I want to send inquiries to a websites and automatically download the results. The process is this:
1. Open link to website
2. Login
3. Process a set of inquiries sent to the website and download the file that the website will return. The website allows to submit an inquiry, click process then it processes that inquiry and send the result afterwards. I want to be able to input multiple inquiries which will be submitted to the website one at a time.
4. Save all downloaded files into a folder

I don't know if 1 and 2 can be skipped using VBA? The website works best with Chrome (because it can auto-download files in Chrome) and I research and bit and it seems like VBA only works with Internet Explorer?

The website needs the user to log in first before allowing downloading of files. I'm not sure if that can be skipped, say I already login in Chrome then the VBA or program goes to that link, submit inquiries and download the files?

What do think?

Thank you for all the help!!!!!!!!!!!!!!

 

[shg]

it seems like VBA only works with Internet Explorer?

See How To Automate Firefox Or Chrome With Excel VBA And Selenium

 

[Norie]

I think Python would be more suited for this, in comparison to VBA anyway.

 

[lumineers01]

See How To Automate Firefox Or Chrome With Excel VBA And Selenium

Ooh. Thanks! I found that selenium thing, but saw it requires an extra step so I moved to the next tab. Lol. But thank you Sir! I will read this one.

 

[lumineers01]

I think Python would be more suited for this, in comparison to VBA anyway.

Thank you for your reply! I've used Python programs and its easier, and seems like the possibilities are endless so I actually thought of it first but since I since I know *just a bit* more <layer highlight="term-4" class="searchwp-term searchwp-highlight-searchwp-highlighting">about</layer> VBA, I asked. So Python seems a great pick for this, the problem is I don't know that much yet <layer highlight="term-4" class="searchwp-term searchwp-highlight-searchwp-highlighting">about</layer> programming. I better research more <layer highlight="term-4" class="searchwp-term searchwp-highlight-searchwp-highlighting">about</layer> this. Thank you so much!