code stage

*Solved*......... Hi I'm looking to summarize all values in a specified column in a collection through a code stage (not looping). In this collection called "Collection", I want a sum of all values in column "Numbers". I don't read or write C# very well, so can someone provide a code that...

Hi, I have a Code stage that creates Pivot Table in Excel. The first part of the code is general and the second part is there to describe how the Pivot Table should look like. I would like to be able to dynamically change the second part whenever I want to change the Pivot Table layout. How to...

Hello, I'ｍ trying to write a very easy code just to get used to Code Stage, but the message "Internal : Could not create an instance of the code class because the class is not compiled" keeps popping up and I cannot go further. Do I have to do something in Initialize page? ＝＝＝＝＝＝＝＝＝＝ Dim...

I have to check whether a document is actually a pdf or not and someone hasn't renamed a .png to .pdf. So for this in Blue Prism I am writing a custom code using C# in an object. Actually I have to check the file binary MIME type and for this I am importing urlmon.dll in Code Options as a...

For example it seems possible to access elements of a collection in a code block Dim i As Integer For i = 0 To col1.Rows.Count - 1 outText += col1.Rows.Item(i).Item("Order number") Next i But what if i want to do something ore complex like call an action within th Dim i As Integer For i...

We have a dragging bar to change the speed modes while in debugging but can we change the speed in run time with any code ? please help thanks

I want to create a page in the ms excel vbo to create freeze panes i have recorded a macro and the code for it is With ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ActiveWindow.FreezePanes = True The major issue is use of ActiveWindow as it can't be use like ActiveWorkbook or...

Hello All, I am trying to get the Pages and Word count from the given folder "Get Files" action in "Utility- File Management" VBO. In Patterns CSV I'm simply using "*."* to get all files but in collection out I'm not getting "Page" and "Word count"column. I checked the Code stage for Get...

Hello, I'm working on a project and as a part of project requirement, I need to get the page count from of each MS world file from the total files. I'm looking for the VBO Code based solution as volume is large for the files. I've below VB code to get the page number for active document but not...

Hi, I am using SAP for a use case where I need to highlight a row and press a button. However, when I tried to use the SAP mode to spy this row that I need to highlight, it's unable to select that row as a unique element. Please refer to the image. I used the code stage (used SAPs built in...

Hi everyone, my problem is that i wanna make request from blue prism to get data from a ticketing system, i tried to do that with a vb.net code but unfortunately it doesn't work, also i try to do this with Webservices - REST BP object stage but it doesn't work, it show me an error of...

I need to be able to create a pivot table from a selected range, manipulate the style, filters, data, etc. It would a great help if someone could clarify this for me. Thanks!

Hi , Can anyone help me with the below query: ( Using Code and Decison stage) How to kill already open Internel explorer and start and launched a new IE

Hello, I have created my own PowerPoint Object and am having difficulty on a save and close action. My guess is I have the wrong syntax for save. Blue Prism will successfully close the PowerPoint, but will not save. I have copy/pasted VBA code to try and save and have been unsuccessful. If...

Hi everybody, I'm trying to insert a pie chart into excel worksheet. For this sake I recorded a macro and used its code in Code Stage in the Excel VBO. Here's what my code looks like after the modifications for use in BP: Dim wb as Object = GetWorkbook(handle, workbookname) Dim ws as Object =...

Hi, i need a get of process id of a process named "WerFault.exe". The code stage have like input parameter the name of process (string) and the output, the number id (Integer). Help me please!

need c# (linq) code stage, to sum all rows in one of column in a collection, i want to use linq as i have huge number of records here i had "amount" as a column the output should in a text or number i.e 1234+4321+0099+9900 = 15554

When I try to kill the process from task manager it gives error at initializing stage can any one help me please I am new to Blue prism thanks error : Page: Initialise Stage: Stage1 Type: Error Action: Validate Description: Compiler error at top section line 30: Type or namespace definition...

Hi, I am getting a below error while opening a BO. Description: Compiler warning at top section line 10: Namespace or type specified in the Imports 'tdclient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public...

Is it possible to have Blue Prism native action for example 'Get Item Data' inside a code stage? How the code should look like? Or is there an possibility to get queue data by code stage? Thank you for your help