Make clickable web hyperlink from linked images, list.txt...

A while ago I wrote a function which gets data directly from Excel which is, in my opinion, unfairly ignored by the scripting community.

And here I wrote a quick & dirty script that does what you want (at least, as far as I understood your requirements).

Here I posted the package:

• script
• excel file
• before and after InDesign documents for testing
  
• links

The starting point: PNGes are placed, no hyperlinks created yet.

The data in Excel file

I used some links to my site because yours don't work.

Run the script and select the xlsx-file

For long spreadsheets the progress bar is useful

The script completed

Hyperlinks have been created and are working

Finally, if you don't like the result, you can 'Undo' the whole script

Hope it helps!

Kasyan

P.S. Warning: this script illustrates -- in the simplest possible form -- the approaches I use for automating common tasks such as mass-production of hyperlinks and using existing data in Excel. I don't promise it would for everyone on all occasions.