Help required to Convert Numbers to Hyperlinks

[manoj18071965]

In an excel I have a list of numbers in column A and there Hyperlinks list in column B.

Is it possible to make convert Column A number to Column B links

 

[Gary McMaster]

Maybe the "Hyperlink" function?

Gary

Excel Workbook
	A	B	C
1	10	http://www.mrexcel.com/	10
2	20	http://www.yahoo.com/	20
3	30	http://www.google.com/	30
All

 

[manoj18071965]

Thanks a TON!!!

It really works

 

[manoj18071965]

Can you please help me on below case also:

On the basis of Patent Number I want to download its PDF file from website.http://worldwide.espacenet.com

Example: If I search Patent number US7157984 on http://gb.espacenet.com/search97cgi/.../en/number.hts
I reach to following address http://worldwide.espacenet.com/searc...&Submit=SEARCH
Now if I open the provided link on this page (1. MEMS-based, computer systems, clock generation and oscillator circuits and LC-tank apparatus for use therein)
And then press 'Original document' link (Provided on the middle left side)
I reach to Original document page
Here If I press Download link, I reach to Espacenet Verification window.


I only want to reach till here only and then after I can further manually download the pdf file.

Thanks,
Manoj Kumar

 

[Gary McMaster]

Sounds like you're asking for a lot more than the Hyperlink function can do. If you search this forum for "InternetExplorer", you'll find lots of examples of sending data to/from web pages using VBA. I've only tinkered with this topic. There are others here that could give you some expert advice on automating IE.

Gary

 

[manoj18071965]

Thanks for the help!!!