jahjah Posted March 24, 2011 Posted March 24, 2011 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 Posted March 24, 2011 Posted March 24, 2011 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 Posted March 24, 2011 Author Posted March 24, 2011 (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 hyperlinkrachel_v1.1.au3 Edited March 24, 2011 by jahjah
Tvern Posted March 24, 2011 Posted March 24, 2011 Maybe if i give you my script you will see what i meanOnly 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 Posted March 25, 2011 Author Posted March 25, 2011 OUpsss No answer maybe i made some mistake when i explain
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now