Download files listed as URLs in a spreadsheet?

Check that there is a space after "curl " and before " -o $HOME/Desktop/

do shell script "curl " & item 1 of theItem & " -o $HOME/Desktop/" & item 2 of theItem

As a test, try this the excel worksheet (it worked for my test):

Col A Col B

www.pdf995.com/samples/pdf.pdf test.pdf

Also, for any error, can you post a screenshot of the [replies] in Applescript

(don't post any usernames:passwords):

This Applescript will read the current Excel Worksheet (with the URL in Col A and the name of PDF in Col B) and d/l to the Desktop.

tell application "Microsoft Excel"

tell active sheet

tell used range

set rc to count of rows

end tell

set theList to get value of range ("A1:B" & rc) as list

repeat with theItem in theList

do shell script "curl " & item 1 of theItem & " -o $HOME/Desktop/" & item 2 of theItem

end repeat

end tell

end tell

This does not handle username and password authentication, but can easily be added to the curl command.

Take a look at: man curl There's options to deal with passwords. Googling curl password can also give some help on dealing with passwords (see; http://stackoverflow.com/questions/2594880/using-curl-with-a-username-and-passwo rd) (but you need to be careful in sending passwords in the clear).

So, changing:

do shell script "curl " & item 1 of theItem & " -o $HOME/Desktop/" & item 2 of theItem

to:

do shell script "curl -u username:password " & item 1 of theItem & " -o $HOME/Desktop/" & item 2 of theItem

(but see warnings re: username and password in man curl)

thank you for the excellent advice, Tony.

would you be kind enough to let us know if/how we can adjust your example to use, say, column 3 and 4 of the same excel file to extract username and passwords from there?

thanks in advance

George

Col 1 and 2 in Excel is Col A and B,

So to change to Col 3 and 4 just change to:

set theList to get value of range ("C1:D" & rc) as list