excel

  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

    Can't specify a Workbook Name when using Open Instance (Excel VBO)

    Hello, I'm trying to use a mixture of both the default MS Excel VBO actions, as well as some I made myself which are placed in an Extension object. Just now I am: • Creating an Excel Instance in the MS Excel VBO • Creating a new Workbook (normally named Book1) • Writing a collection to the...
  4. S

    Excel VBO create instance in debug mode Issue

    "Internal : Could not execute code stage because exception thrown by code stage: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)" We are getting this error while we are using Excel VBO create instance in debug mode.
  5. A

    Excel Formula Issue using BluePrism

    5 Home Microsoft Excel Select the language Select the language (English) English (Deutsch) German...
  6. A

    Convert text file(Notepad) to Excel using Blue Prism

    This is the text that I need to convert. I tried to put it in a Data Item and then using Split Text to split it. The result is saved in a Collection but only in one column. Is there any other way to throw this text in a collection without losing its structure and to create 6 columns and 4 rows...
  7. F

    Blue Prism changes extracted date to previous date while reading from Excel(using OLEDB)

    Hello Everyone, I am trying to read date from a particular cell(Date format) in Excel(using OLEDB). Whenever the date is read, in the output the date changes to its previous day. Eg:- If the date in the cell is 17/02/2021 after reading in Blue Prism the output shows 16/02/2021. If...
  8. A

    Convert text file(Notepad) to Excel using Blue Prism

    This is the text that I need to convert. I tried to put it in a Data Item and then using Split Text to split it. The result is saved in a Collection. Is there any way to throw this text in a collection without losing its structure?
  9. F

    Find and Replace Excel Code Stage

    I am trying to implement a "Find and Replace" code stage within my Blue Prism Excel Object. The code stage is producing an error with: "Internal : Could not execute code stage: Parameter count mismatch." Any help would be much appreciated The Inputs are as follows: Handle Workbook Worksheet...
  10. B

    How to do attach in a excel web add-in

    Hi All I am doing the automation activity for a excel web add-in , where when I launch a template - it consist of browser portion enabled and I have to automate that browser part and excel side of it as well. So I would like to know how to perform attach operation for the same. Can someone...
  11. T

    Microsoft Excel Data Connections - Alter Command Text

    Hi everyone, I'm trying to change Command Text box in Connection Properties (see picture). It is an existing data connection in Excel and I need to change the query. I already found this thread discussing altering Connection String but I was not able to alter the code for my purposes. What...
  12. T

    Excel process running after closing instance

    Hi, I have a problem when trying to close Excel. When I use MS Excel VBO::Close Instance, the Excel would close, but process in Task Manager is still seen running. The same goes when using MS Excel VBO::Close All Instances. Process: - Export table from 3rd party program. Program opens MS Excel...
  13. D

    Read row starting from a specific cell

    Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell? P.s. it's better to extract non-empty cells. Thanks in advance.
  14. 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...
  15. 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...
  16. R

    How to Copy range as image

    Hello, I'm new to Blue Prism, and looking for a way to copy Excel range as image and paste it to Outlook item. I know "CopyPicture" method in VBA but I have no idea what I can do in Blue Prism. Maybe I will have to use Code Stage? I appreciate if any one of you give me an advise. Thank you.
  17. D

    Solved Run Time Error Macro freezes BluePrism

    Hello, i'm currently encountering an issue with my project. I have to download multiple excel files from an Intranet. Then, open them one by one and call a specific macro (The same macro exists in all the files). While running the macro, i noticed that there's a runtime error with the macro...
  18. R

    Convert Excel version to Excel 365

    I automated another program that outputs reports in Excel format - however, the Excel format it saves the files as is older. I have Blue Prism interact with the program and save it to an Azure share - the Excel files are then imported by another system process. The other system process is...
  19. 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...
  20. H

    Excel VBO - Move Worksheet Error

    Hi, Please help me out in moving the worksheet from one workbook to another. I'm getting the Bad index exception(PFA). Please help!
Top