How to insert a URL in Excel cell

[ThomasQ]

Hi!

I'm trying to insert an url from a website into a Excel cell. I know the indexnumber, so I can click the link with the _IELinkClickByIndex command, but how do I copy it, so I can insert it in excel?

Help a n00b out! >_<

Thanks!!

Edited August 4, 2009 by ThomasQ

[muhmuuh]

Look at the help file. It holds all secrets of the universe >_<

$link=_IELinkGetCollection ( $ie, $index)
$url=$link.href

search the forum for Excel UDF to see how to insert it in excel

[ThomasQ]

Thanks! It's still not clear though.. Once I get the URL as $oURL, I'll be fine getting it in excel. ALso I get the _IEgetcollection command, but I don't get the $url=$link.href command. That .Href at the end, that's wat chooses the last Link from the collection?