Blue Prism Product

 View Only
last person joined: 9 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Param in function vba

    Posted 05-24-2018 21:19
    Hi, I have this code : Dim ws, excel,sheet As Object ws = GetWorksheet(Handle, Workbook, Worksheet) ws.Activate() excel = ws.Application sheet = excel.ActiveSheet ws.Range([range]).RemoveDuplicates(Columns :=Array(1,1), Header:=[Header]) input :range - string (ex:"B:B") input :Header- flag(ex:"True") input : Columns - ???   This code implement in Excel vbo RemoveDuplicates function of Excel. But I need help because I do not understand how to pass the argument Array (x, x) in bluePrism!? How should I declare it? Knowing that this argument Array must be dynamic. If I put the function in a vba excel, it runs correctly. Here I have the following error at compile: 'Array' is a type and can not be used as an expression. if I replace with a "string", it does not work   Bonus question (still in Excel VBO): how to do when you have a function that can take optional arguments to pass empty values? for example in the function:         ws.Range([range]).TextToColumns(Destination :=destinationRange, _                                 DataType :=[DataType], _                                 TextQualifier :=[TextQualifier], _                                 ConsecutiveDelimiter :=[ConsecutiveDelimiter], _                                 Tab :=[Tab], _                                 Semicolon :=[Semicolon], _                                 Comma :=[Comma], _                                 Space :=[Space], _                                 Other :=[Other], _                                 OtherChar :=[OtherChar], _                                 FieldInfo :=[FieldInfo], _                                 TrailingMinusNumbers :=[TrailingMinusNumbers]) Can become: .TextToColumns( "A:A", 2, 4, , , , , True, , , , , , ) I dont find the way in bluePrism to pass him the null arguments! An idea ?

  • 2.  BP code stages use .Net code…

    Posted 05-25-2018 20:12
    BP code stages use .Net code, not VBA. The 2 languages are similar but not identical and you can't paste a macro into BP and expect it to work, you have to write .Net code. The VBA can act as a good skeleton, but it will need to be adjusted. Exactly how you do that is too big a subject for a forum.

  • 3.  RE: Param in function vba

    Posted 09-02-2020 23:54
    Create an integer matrix 

    Dim matrix = New Integer(6, 1) {{1, 1}, {2, 1}, {3, 9}, {4, 1}, {5, 1}, {6, 1}, {7, 1}}

    Then you could use this as pararemter for FieldInfo


    Full code

    Dim wb, ws As Object
    Dim excel, sheet, range As Object
    Dim matrix = New Integer(6, 1) {{1, 1}, {2, 1}, {3, 9}, {4, 1}, {5, 1}, {6, 1}, {7, 1}}


    wb = GetWorkbook(Handle, Workbook)
    ws = GetWorksheet(Handle, Workbook, Worksheet)

    excel = ws.Application

    excel.Selection.TextToColumns (Destination:=excel.Range(Cell_Reference), DataType:=1, _
    TextQualifier:=-4142, ConsecutiveDelimiter:=False, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
    :=Delimiter, FieldInfo:=matrix, TrailingMinusNumbers:=True)

    Success = True

    Catch e As Exception
    Success = False
    Message = e.Message
    wb = Nothing
    ws = Nothing
    excel = Nothing
    sheet = Nothing
    range = Nothing
    End Try

    Miguel Carrillo

  • 4.  RE: Param in function vba

    Posted 09-03-2020 14:13
    That would be Type.Missing in .Net, although better use named arguments like Miguel suggested.

    sourcerange.TextToColumns(Type.Missing,1,1,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,{1, 1},Type.Missing,Type.Missing)

    Andrey Kudinov
    Project Manager
    MobileTelesystems PJSC

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements


Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.