Hello. I have a spreadsheet with URLs in A1:A9 (expandable) and wish to open each of these links in firefox . Here is my algorithim.
Check whether column A is Empty. If Empty, do nothing, else
open the first url in column A in firefox and let the URL be loaded .
Then close browser after a delay of 20 seconds.
Open the next URL and repeat the above process until the URLs in column A is exusted
I have this command that opens the firefox: shell("C:\Program Files (x86)\Mozilla Firefox\firefox.exe") but I do not know how to refer it to column A of sheet1 to open the URLs. I'm stuck
Check whether column A is Empty. If Empty, do nothing, else
open the first url in column A in firefox and let the URL be loaded .
Then close browser after a delay of 20 seconds.
Open the next URL and repeat the above process until the URLs in column A is exusted
I have this command that opens the firefox: shell("C:\Program Files (x86)\Mozilla Firefox\firefox.exe") but I do not know how to refer it to column A of sheet1 to open the URLs. I'm stuck