Dear all,
This is what I want to do essentially:
I have an Excel file where in cells A1:An there is a weblink in each (and nothing else in the file). What I need is a macro or a script that would sequentially open each link and then perform two clicks which would lead to a download.
Essentially the script would need to do the following:
1. Open link in A1.
2. On the page that results, search for the button labeled and titled "String1" and press it.
3. This opens a new page in a new window. On this new page, search for the button named "String2" and press it. This will automatically start the download of the file on my local disk, in whatever folder configured in Firefox.
4. After interval t has passed, open link in A2 and keep doing the same thing until hitting an empty cell cell (cell An+1).
Any help is highly appreciated.
thank you![]()
Bookmarks