How to get the text of a generated URL

[ThomasQ]

Hi!

I'm trying to make a script that will read URL's and paste them into an excel sheet. I'm almost done, the last hurdle is this:

When using _IELinkGetCollection, it returns the URL's, not the text wich is visible on the website. How do I get the text?

Example; the website shows 1445623 - Speer Werk CV - info@speerwerk.be, but returned is the URL it's linking to. I need the text it self.

Many Thanks!!

[GEOSoft]

See _IEPropertyGet() where the property is "innertext"

I think it should be something like

$oLinks = _IELinkGetCollection ($oIE)
For $oLink In $oLinks
    MsgBox(0, "Link Info", _IEPropertyGet($oLink, "innertext"))
Next

I could be wrong on this but I'm sure Dale will come along to correct it if I am.

[Piyush]

I think you can get the text with _IEPropertyGet ( ByRef $o_object, $s_property )

Set the $s_property to "innertext"

[ThomasQ]

Yes many thanks..

_IEpropertyget does indeed return the text of the previously collected links with _IELinkGetCollection..

I still have a little problem integrating it into my script:

$oLinks = _IELinkGetCollection ($oIE)

$klantmail = _IEPropertyGet($oLinks, "innertext")

Local $iLinkIndex = 15

Local $iCurrentIndex = 0

For $oLink In $klantmail

$iCurrentIndex += 1

If $iCurrentIndex = $iLinkIndex Then

_ExcelWriteCell ($Cleansheet,$klantmail, "D4")

_ExcelBookSaveAs($Cleansheet, "C:\Documents and Settings\Admin\Desktop\Projects\Sheets\ToDo\klant1", "xls")

Endif

ExitLoop

Next

The Idea behind this was that, if $klantmail is the object collection, but with text (btw, whats the difference between an array and an object collection?). Any suggestions?

Thanks!

Unfortunately, this doesn't return anything or writes it to the excel sheet.

Edited August 7, 2009 by ThomasQ

[GEOSoft]

What are you attempting to do here? It just doesn't look right but it might be me.

_ExcelWriteCell ($Cleansheet,$klantmail, "D4")

[ThomasQ]

I'm trying to write the innertext of the Link indexed 15, which I fail to name $Klantmail, to excel sheet D4..

Anyone any ideas whats wrong with my script?

Many Thanks!

[Juvigy]

remove the 2 excel functions and put a msg box to verify that $klantmail is OK.

If it is OK then the excel functions are the problem