-1

In Spreadsheet: In Column A I have a list of fully qualified URLs.
In ColumeB is a matching filenames to be used to save PDF

I need to access Safari (or Chrome if it is easier) with the first (A2) URL, when the resulting file (a .pdf) is obtained, save it as the filename in B2. Then step down to use A3 and B3 to end of the range.

It is pretty simple logic I just don't seem to find the basics of using the browser to download the file.

All the URLs in Column A are something like...https://xyz.xxx/uploads/a0482f61fea0df571a9ed7bd5c899ed6.pdf All the filenames (B2, etc) will be something like "PartNumberxxxx.pdf"

Logic is something like: Set the Range for all URLs in Col. A Use the URL in A(currentrow) to access Safari and Get the resulting pdf (which they will all be) Rename PDF from anonoymous file name to File Name in Col B(current row) Store/add the renamed pdf to a folder such as /Users/user/Downloads/Drawings/ Cycle to next Row until end of range.

The result will be a complete set of filename.pdf stored in the folder something like PartNumberxxxx.pdf

Like I said...pointing at and sequencing through the lists of URL & filenames I can do; but how do I obtain the file from safari and store it?

braX
  • 11,506
  • 5
  • 20
  • 33
Dward
  • 1
  • 1

0 Answers0