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?
Hello! Can you help me, please?
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)
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?).
you can get the hyperlink like below.
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.
Can you attach the sample xl file.
Sorry, the text editor cut the link itself.
OK, I will now post the file along with the excel file as an example.
This link will not work. Becuase it has htttp instead of http. What is the output that your expecting ?
I apologize again, I made a mistake again…
Here is the correct version of the link:
I understand that this is output
What is your expected output ?
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.
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)
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 キロバイト)
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.
I have change sample that I have attached it here.
Excel_Find_and_Replace.zip (24.2 KB)
I understand! (^▽^)ノ
I have developed a new activity to set the border to the range or cell inside the workbook.
Detail of the properties
Line Style :
Border Color :
You can set the color like .“Color.Red”.
Border weight :
you can specify the border weight like 4.
I have developed new activities called “Get Hidden Columns” and “Get Hidden Rows” version 10.0.0.
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 :
Special thanks to @Gnaneshwari_Pinna . She gave the idea made these activities.