SS&C Blue Prism Community

NicolasSahli

Hi PeopleI have this task where it needs to be checked if a Cell in excel is colored or not. How can this be solved with Blue Prism? Is the only way to achieve this a self developed code stage or are there other simple work arounds? Thanks in advance...

NicolasSahli

HiI want to make a query on our BluePrism Database. I want to extract the number of worked elements per resource. The goal is to get a table with each resource and its number of items worked on this day.Has anyone tips on how that query should look l...

NicolasSahli · 03-07-24

HelloI am trying to read Emails from Outlook with the "MS Outlook Email VBO" using the action "get received Items". When executing the action everything goes fine, except that there is no Items in the output collection, even when there should be plen...

NicolasSahli · 11-04-24

HelloI would like to save an excel file with a "read only" protection. This means the next person who opens the file can only read the document and not edit it. I tried the Action "Protect Workbook" but I didn't manage to make it work. Is there any t...

NicolasSahli · 03-04-24

Hello I would like to sort the column M in ascending order in this Excel file. I was able to turn on the filter on Row 10 with the Action: "Turn on Autofilter". But then when trying to apply the "Add Sort to Autofilter" action, nothing happens. Is it...

NicolasSahli

Thank you for your Help and Ideas. I ended up just creating a custom code stage which extracts the Value of the Color of the Field.I did it with that simple line:ColorValue = GetInstance(ExcelHandle).ActiveCell.Interior.Color

NicolasSahli · 03-07-24

Thanks for responding.Actually just tried to send an email and got this error:Internal : Could not execute code stage because exception thrown by code stage: Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

NicolasSahli · 03-04-24

Thank you! This worked out! I was able to open chrome like you said and then with the keystroke "Enter" to click the Ok button in the PopUp!

NicolasSahli · 18-01-24

The Excel file has 30 columns which are mostly filled out. And with forever i mean it takes around 10 mins to execute this action. The weird thing is on the older version of the VBO it was possible to read the entire file in matter of 2-3 seconds (I ...

SS&C Blue Prism Community

User Statistics

User Activity

Detect colored Cells in Excel

Query on BluePrism Database to extract worked items per resource

Outlook VBO to get Received Items does not work

Save Excel File as Read only

Sort column in Excel

Re: Detect colored Cells in Excel

Re: Outlook VBO to get Received Items does not work

Re: Select Certificate when opening Browser application

Re: Get Worksheet as Collection (Fetch Data With Method = "Text" is super slow)