Open Multiple URLs from Excel using applescript
Hello, thanks in advance for you help.
I am trying to open multple Urls from a list in an excel sheet. When I run the script I would like it to open all the urls into differnt tabs of safari.
I have got as far as geting a single cells url to open in a new tab in safari but I can't figure out how to repeat it for the whole row.
here is what i have so far
tell application "Microsoft Excel"
open "Macintosh HD:Users:david:Desktop:apple script editor:product_search_tool.xlsx"
set myURL to value of cell "b2" of sheet "Sheet1" of document 1
end tell
tell application "Safari"
activate
try
tell window 1 to set current tab to make new tab with properties {URL:myURL}
on error
open location myURL
end try
end tell