Archive: Automate the Input of a dropbox PDF link into excel

Budget 33$ per month

Posted: 5 years ago

Closed

Description: I require an automation process to first create the shared web link from a string of PDF's in a folder and paste each individual weblink into a new row in an excel sheet.

I have used VBA to get the file location but that is not suitable for my application.
I have found a process on a mac using apple script but not found how to do this on a PC.
https://michaelkummer.com/tech/apple/dropbox-link-applescript/

Ideally i don't have to move or copy the files to a new location however i believe that the only way would be to set the file path to a 'Hot box' so when you dump the files in it creates a 'dropbox link' and creates a new row in an excel template file.
Skills:
automation,macintosh,software development,VBA programming language,Visual Basic programming language