Sign in to follow this  
Followers 0
jahjah

Lost my hyperlink in "arraydisplay"

5 posts in this topic

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



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

#3 ·  Posted (edited)

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

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

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  
Followers 0