code stage

  1. K

    Sum column in collection - C# code stage *SOLVED*

    *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...
  2. T

    Dynamically change part of code in Code stage

    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...
  3. R

    Code Stage -"class is not compiled"

    Hello, I'm 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...
  4. R

    Using urlmon.dll in CodeStage (C#) for checking MIME type of document

    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...
  5. A

    how can I call an action (element) from the code block (element)

    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...
  6. G

    Important and challenging - blue prism

    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
  7. K

    ActiveWindow option in code stage

    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...
  8. R

    Enhancement to Code under "Utility- File Management" VBO to Get Pages and Word count

    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...
  9. R

    Solved CODE Stage to Get page count in MS Word Document

    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...
  10. M

    Can't select item in SAP using Code stage

    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...
  11. A

    how to Make ( get and post ..... ) Request in blue prism ??

    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...
  12. F

    Can anyone post a guide on how to add pivot functionality to default Excel VBO?

    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!
  13. V

    How to kill already open Internel explorer and start and launched a new IE ( Using Code and Decison stage)

    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
  14. B

    Close and Save PowerPoint

    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...
  15. J

    Inserting Pie Chart in Excel and getting error HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)

    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 =...
  16. K

    Get ProcessId from code stage

    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!
  17. V

    c# code stage to sum all rows in one of column in a collection

    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
  18. M

    How to kill task manager process BluePrism

    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...
  19. D

    OTAClient.dll unable to load

    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...
  20. C

    BP Action in Code Stage

    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
Top