Jump to content
Sign in to follow this  
jahjah

Lost my hyperlink in "arraydisplay"

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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 by jahjah

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
jahjah

OUpsss

No answer maybe i made some mistake when i explain

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×