Capturing hyperlinks from external site

[nobleprince]

Hi folks,

I have a list of names in a spreadsheet as shown on the attached file. The requirement is to be able to capture the hyper links and store them within the spreadsheet (column D). There are over 1000 records.

The requirements are as follows:

- The user should press "Select All" or check the relevant name(s) and then press the "Capture URL" button.
- When the "Capture URL" button is pressed within the spreadsheet, the macro/script should go to the name (Column A) hyperlink.
- Then the URL (or company) name should be taken from the "Current" field within the LinkedIn profile, e.g. bbc.co.uk (without the www).
- The URL name (e.g. bbc.co.uk) should be copied and pasted into Column D within the spreadsheet.
- This should be done for all the names that were checked / selected.

Any assistance will be much appreciated.

Thanks!

[Leith Ross]

Hello nobleprince,

No can do. You should read Linkedin's user agreement.

Here is the part that pertains to your post:

10. # Deep-link to the Site for any purpose, (i.e. including a link to a LinkedIn web page other than LinkedIn’s home page) unless expressly authorized in writing by LinkedIn or for the purpose of promoting your profile or a Group on LinkedIn as set forth in the Brand Guidelines;