weavesilk.com

my tank

Tanki Online

http://tankionline.com/battle-en26.html#

Custom Function in Excel to get the url of the cell

i am working on small excel project to get the url

i copy the links from the webpage straight into excel
well the url or hyperlink its there but the problem is...
i need to insert them into mysql database and...
there are 10,000 records.


































i am still using office 2007 don't whether the function is available in the newer versions..


so here are the steps for ppl using excel 2007..........

open a macro enabled workbook or save it later as .xlsm


Alt + F11 open the visual basic editor

insert a new module

paste the following code (highlighted in yellow)


Function GETURL(HyperlinkCell As Range)

 GETURL = HyperlinkCell.Hyperlinks(1).Address

End Function

save and close the editor

now go back to the sheet view