FYI - If you click Yes to download attachments then it appends a number to the default csv filename and creates a subdirectory with the same name as the file (less csv). Attachments are dumped in there.... Interested to know if attachments open when you click... On Mac, it's been problematic.. Are you Mac or Windows?
Doesn't matter, it should work on any platform. When in the Excel file, on the right, there are links. Hopefully one or more of them will work for you. Please let me know which.
Also if on a Mac and using later versions with Office, you have to grant permissions to the attachment folder. You will see extra lines at the top of the file to explain this. You have to do this once whenever you open the file. It's not necessary on Windows or Linux.
Well, as for sending to someone else.... You will have to do it carefully. A few points.
There are two columns for file links. The second is relative - so this should still work. It's important that the spreadsheet exists in a directory, and then the attachments folder under that (as it is now). I suggest you create a zip from the csv directory to maintain this structure.
If they are on windows or Linux, that's it...
If a Mac, read on.... (some experimentation required)
the cell a6 must be an absolute path, it cannot be relative. Try setting it to (3/s):
enter so it goes blue. test it... save file.
then in finder, select the csv and the subdirectory
right-click, select compress
send this zip
get the user to unzip, edit and click a6, then see if it works.
If you like, try this, and send to me to test. Please send me your email address, and I will reply..?
Update build 1001 - attached. OK, I've switched cell a6 back to the full path.... small bug fix too, and now the script also creates a zip file for you too... This can be sent and unzipped the other end. The only dodge on Mac is that they have to edit cell a6 to be the path where they unzip and press enter, then click, and grant access. Anyway, let me know how you get on?