Lost my hyperlink in "arraydisplay"

[jahjah]

Hi,

I try to display a array in a 2d array with the "arraydisplay fonction" it's working well but i lost my hyperlink.

I haved hyperlin in my excel file i wanna retreive them in the array

does somebody know how to do it, if it's possible

Thanks

[Tvern]

An example would be usefull, but I suspect you need to use something like:

$sFormula = $oExcel.Activesheet.Range("A1").Formula

On the cell, or range containing the hyperlink. If needed you could ready all formula's to one array, then all value's to another and then move all hyperlink formula's from array 1 to array2, conserving the calculated values of other formula's.

I don't have office installed atm as I just reinstalled windows and didn't need it yet, but I think something like that should work ok.

[jahjah]

thanks for your answer but i try to understand the way you show me but no way

Maybe if i give you my script you will see what i mean

Here ly step

1-Search a word ($class or $package or $ indicator...)

2-when i found the word make a filter in my excel file

3-Display in a array the filter result

But in my array i don't have my hyperlink

rachel_v1.1.au3

Edited March 24, 2011 by jahjah

[Tvern]

Maybe if i give you my script you will see what i mean

Only one way to find out!

The rest of the post didn't make much sense to me, perhaps the script will give some context.

[jahjah]

OUpsss

No answer maybe i made some mistake when i explain