Recent content by mbailey

  1. M

    How can an Excel handle be shared?

    Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...
  2. M

    How can an Excel handle be shared?

    Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...
  3. M

    Are environment locks released when process ends?

    VJ, To expand on Kamal's point, we are running this process with multiple bots and the environment lock is not being acquired with a preferred token. The only process aware of the token value is the process that acquired the lock. Additional bots running the same process cannot release the lock...
  4. M

    Maximum text data element size

    We are loading text into a Blue Prism text data element and I cannot find any documentation on the maximum size of a text data element. Does such a limit exist? I understand that BP itself could encounter a memory error if GB of data were loaded into anything but I just want to know if Blue...
  5. M

    Writting a backslash (\) and any other special character

    BahavanaKalva, I have a similar issue in which manually entering a string with one or more embedded commas into an SAP text field works but making the entry with a Blue Prism Write stage produces the "Exception has been thrown by the target of an invocation" error. Enclosing the string in 'at'...
  6. M

    Blue Prism-Excel-How detect and handle prompt when saving file

    I should have mentioned that this directory is used by people and other non-BP processes. I could use locks to ensure that only one BP process tries to save at a time but that would not prevent other saves from causing this problem. If this were a C# or VB.Net program, I would write an event...
  7. M

    Blue Prism-Excel-How detect and handle prompt when saving file

    Hi, We have an issue with Blue Prism (BP) saving Excel files to a directory that encrypts the file and locks the directory to other writes while the encrypted save completes. If two BP processes attempt to save files in the same directory at the same time, one process will receive a Microsoft...
  8. M

    Copy a worksheet bewtween two workbooks in different Excel instances

    Hi, I have a process that will execute many SAP transactions, some returning large amounts of data, and create an Excel workbook (Output.xlsx) with separate worksheets containing the data from each SAP transaction. As each SAP transaction is run, we have SAP export the data to Excel. For...
  9. M

    Attachments to digitally signed Outlook 365 emails

    My company recently migrated to Office 365 and encountered a problem in which none of the attachments to digitally signed Outlook 365 emails except the smime p7s are visible to the RPA bot. The issue affects Chrome version 78.0.3904.108 and IE version 11.864.17763.0, which are the only browsers...
  10. M

    How determine process name

    Hi, I'm writing a reusable business object action to acquire an environment lock and, if unsuccessful, to determine if the process currently holding that lock is making progress by creating work queue items in the most recent passage of a specified time span. If no progress is being made, an...
  11. M

    How copy collection to clipboard

    Sachin, That worked great, was easy to implement, and uses a small modification to existing object code. Thanks for the help. Regards, Michael Bailey
  12. M

    How copy collection to clipboard

    Hi, My process interacts with SAP and Excel. One of the tasks is to copy a column of values (no more than 100 items) from an Excel worksheet and paste it into separate rows of a table on an SAP screen. I use the MS Excel VBO Select and Copy actions to place the values in the clipboard and the...
  13. M

    How obtain row count from nested collection

    Thanks VJ. That works.
  14. M

    How obtain row count from nested collection

    I have a single row collection (call it Coll-A) that has a nested collection as a field (call the field Coll-B). I need to get a rowcount from the Coll-B collection in the only row of Coll-A. The Collection internal business object Count Rows action requires a collection name parameter so I use...
  15. M

    closing previously opened windows

    Babjee, For each external application, create a flag or count data stage that keeps track of whether you started the external application or how many instances of the external application you started. If the application is closed in normal processing, the flag would be set to False or the count...
Top