VB script, Macro Help!!!. Build a Hyperlink Generator.

[manoj18071965]

Hello,

I have a list of Patent numbers in an excel sheet. I just wanted to know if following is feasible in excel:

1. I need a script so that each of the respective patent number (there 'web home page address' e.g. Patent number: 4456785 http://www.google.com/patents?id=jzs...ed=0CC8Q6AEwAA) can be automatically pasted on next column of each patent number.

2. Please note Patent Numbers available on excel sheet does not contain hyperlinks.

3. I am using MS Office 2007

Hoping for a positive response from you all.

Thanks,
Manoj Kumar

 

[manoj18071965]

Thanks, but it is working for A1 only

 

[manoj18071965]

Formula is only working on cell A1 and not working on others

 

[jkpieterse]

I see now that the patent number in the direct link to the download isn't the same as the one in the link, so my suggestion will not work unfortunately.

 

[manoj18071965]

Yes, Thanks anyways