excel

  1. 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.
  2. 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...
  3. 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...
  4. 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...
  5. 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!
  6. A

    Close one of thee two open excel workbook

    I am opening a new Excel workbook through one excel workbook(AFO) which is already open. Now after opening the new workbook I am getting issues with attaching. But if I manually close the previous workbook(the not required one), then everything seems to work perfectly. Is there a way to close...
  7. C

    Link enables excel opening issue

    I have an link enabled excel workbook, which opened manually gives a pop up to enter credentials to connect to the data source. If the same excel is opened from Blue Prism, it throws a pop up of : Excel has links, if you trust: update or not update pop up. I added an action via code stage to...
  8. K

    Open Excel with Analysis for BI Office Launcher using Blue Prism

    Has anyone here tried to Automate an Excel with Analysis for BI Office Launcher? I tried to use the Open Workbook Action under MS Excel VBO but the Analysis Tab is missing. Please let us know if there is any other way to open the file. Thank you!
  9. C

    Sending email to specific addresses by attaching specific files from folders

    I have a scenario where I have three complex excel files. Each file has thirty to forty worksheets. Each worksheet in excel has to be saved with it's business center number as file name, in a created folder after some data manipulation. For example. file A has 1,2,3,4,centers, and hence 4files...
  10. O

    Filed column doesn't exist error

    Hello, I am getting an error message when using the state in Blue Prism where the data is being read from excel into a collection. There are 30 columns in my spreadsheet and this process works with the first 14 and stops at Column 15. This is the error message I get: 2/18/2020 12:24:59 PM...
  11. J

    How to attach Excel (opened by SAP)?

    Hello everyone, is there a way how to attach the excel which gets automatically opened by SAP when robot is saving report as spreadsheet? But the Excel isn't opened within the RPA Excel instance... So far I kill the excel process and open the excel again but it doesn't feel right, especially...
  12. H

    KILL process EXCEL action results in warning state

    The Utility Environment - Kill Process action unpredictably ends up in a 'warning' state. The process that is to be killed is Excel. Since this Kill isn't working the only way to exit the warning state is by manually killing the process in the task manager, that apparently gets stuck running in...
  13. L

    MS Excel VBO - SaveWorkbookAs

    Hi all, I am currently encountering a problem with the MS Excel VBO - SaveWorkbookAs action. At my client we are in a transition from Win7 to Win10 and I am testing all existing processes and objects. The SaveWorkbookAs action doens't work like it used to on our Win7 resource machine. Nothing...
  14. L

    How to get checkboxes value in excel

    Hi all, How to get checkboxes value and their location in excel ? I tried MS Excel VBO::Get Worksheet As Collection,but get noting.
  15. M

    OLEDB with Excel

    Hi team, Am using OLEDB with Excel (Office 365). When am giving the connection string, its working fine. But when executing the connection, it shows " Error: db_sec_e_auth_failed(0x80040E4D)" error, Can someone help me on this.
  16. L

    Can't open a macro enabled Excel document - Application is busy

    I have a pretty simple process. I want to open an Excel workbook with macros and run a macro. My process looks like this: Start Create Excel Instance Open Workbook Run Macro End I'm getting an error "Could not execute code stage because exception thrown by code stage: The message filter...
  17. S

    excel to csv format error

    Hi, I'm currently converting an Excel file to CSV. Step 1: Get data into collection Step 2: Convert collection to CSV Step 3: write it into a file. It works, but there is a problem with Data format error. For example: Excel value - 9781621577720 CSV value - 9.78162E+12 I'd like to know if...
  18. A

    Excel Macros on multiple Worksheets

    Dear Members, I am new to blue prism and i would like to create a process which involves running a single Macro in different workbooks and different worksheets of excel so can you please help make dynamic values of macros for Blue Prism so whenever macro is running it is picking itself...
  19. C

    Writing Undefined Collection to excel based on column header

    I have 4 columns in a spreadsheet that I need to paste on another workbook. The size and order of these 4 columns on the source sheet vary. The Column names are consistent. I need to paste the columns on the destination workbook in a certain order going by their column name. The solution that I...
  20. J

    Excel OLEDB connection, number format

    Hi, We are developing a robot to automate some reporting analysis and submission to different process owner. Basically we extract data from SAP, make some mapping query in access and then extract data into excel in different report to different user. To write in excel we are using connection...
Top