Hello! Can you help me, please?
When i ty Extract Hyperlink from range M3:M2000 i get a error: “Extract HyperLinks: Bad Index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))”
What can I do to avoid this error?
Thanks.
2 Likes
Hi @Foertsch,
Thank you for you valuable feedback.I had chance to test in various type.Yes it has bug. I have fixed it. you get he package here Version 7.1.0 .
Here i have attached sample for your. But the package is configure in local so. after open the project , configure the package from your local.
Foertsch.zip (47.0 KB)
Thank you
Balamurugan.S
3 Likes
Thanks, it’s works!
Can i ask one question, please… about VBA (hyperlink extractor).
Some links contain a " #" character, and when you try to extract a hyperlink from such a link, only the text before the “#” character displayed. For example, if i try exctract hyperlink from a link "htttp:\example.link.com#com\exampletextetc: i extract only "htttp:\example.link.com".
Maybe you know how to solve this problem, or tell me which direction to go (I understand this is a feature of Excel, but is it possible to fix it?).
Big Thanks.
2 Likes
3 Likes
I’m sorry, I made a mistake in writing the example link. The link looks like this: “htttp:\example.link.com#com\exampletextetc”. That is the sharp part of the link. Without it, link is not functional.
Up to this point, I extracted hyperlinks with using a VBA macro. I used this command in the macro: Hyperlinks(1).Address But the problem is that when extracting a link where the address contains the " # " character, only the part of the link that precedes the "# " character is extracted.
I faced with this problem when using Your activities. And I thought maybe you can tell me what to do in this situation, since links with this symbol are not extracted completely.
If you try extcract hyperlink (for example: htttp:\example.com#com\exampletext), you will see the link text exactly up to the "# " character (htttp:\example.com).
Thanks you for answer.
3 Likes
4 Likes
htttp:\example.com\#com\exampletext
3 Likes
Sorry, the text editor cut the link itself.
OK, I will now post the file along with the excel file as an example.
2 Likes
This link will not work. Becuase it has htttp instead of http. What is the output that your expecting ?
Regards
Balamurugan.S
3 Likes
I apologize again, I made a mistake again…
Here is the correct version of the link:
http:\example.com\#com\exampletext
2 Likes
Hi @Foertsch,
I understand that this is output
http:\example.com\#com\exampletext
What is your expected output ?
Regards
Balamurugan.S
2 Likes
Full text of link.
At the moment, I only get an excerpt: "http:\example.com" this happens with all links, within there is a "#"character.
2 Likes
4 Likes
Thank you for answer.
This " # " character is part of a hyperlink inside Excel. And when I try to extract this hyperlink from Excel, I get its incomplete address. Which doesn’t suit me. You can check this with an Excel file and a process downloaded by me. Just wanted to know if it could somehow be avoided of this or if it’s an internal feature (bug) of Excel.
textexcelactivities.zip (15.1 KB) testuipath.xlsx (8.9 KB)
2 Likes
Hi, @balupad14
I tried to use it, but I got an error.
”Find & Replace: Object reference not set to an instance of an object.”
How should I set the properties?
Excel_Find_and_Replace.zip (27.3 キロバイト)
3 Likes
Hi @ryoko,
Thank you for using the package.
I saw you attachment
The activity can work only inside BalaReva Excel Scope. Don’t use it inside the UiPath Excel Scope activity.
Like below
I have change sample that I have attached it here.
Excel_Find_and_Replace.zip (24.2 KB)
Thank you
Balamurugan.S
3 Likes
Thanks,@ balupad14
I understand! (^▽^)ノ
3 Likes
Hi,
I have developed a new activity to set the border to the range or cell inside the workbook.
Properties :
Detail of the properties
Presets :
Line Style :
Border Color :
You can set the color like .“Color.Red”.
Border weight :
you can specify the border weight like 4.
Thank you
Balamurugan.S
1 Like
Hi all,
I have developed new activities called “Get Hidden Columns” and “Get Hidden Rows” version 10.0.0.
Regards
Balamurugan.S
2 Likes
Hi ,
I have developed new activities called “Insert Hyperlink”, “Get Hyperlink” and “Remove Hyperlink”.
Insert Hyperlink - Add hyperlink (display text and address) to the cell .
Get Hyperlink - Get the address for the hyperlinked cell.
Remove Hyperlink - Remove the hyperlink the the cell (It won’t delete display text)
Insert Hyperlink :
Get Hyperlink :
Remove(Delete) Hyperlink :
Note :
Special thanks to @Gnaneshwari_Pinna . She gave the idea made these activities.
Thank you
Balamurugan.S
1 Like
Anil_G
Anjani_Kapoor
ijanszen1
OGunnarsson
satish_nangedda
lakshmi.mp
Shruthika_r
sudster
Siraj_Balkhis_Reshma_YICC
devasaiprasad_K