vbo

  1. 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...
  2. B

    How to make specific phrase bold in MS VBO

    Hello, I need to make a specific phrase in MS Work bold. My initial thoughts were to use the following actions from the MS Word VBO: Find Text Replace Highlighted Text, and set the 'New Bold' parameter to True (see below). This, however, neither replaces the phrase, or makes it bold. I...
  3. V

    Cant save workbook using Excel VBO

    Hello, I am unable to save a workbook that i created when i use the functionality, for ex Today() for the filename parameter. This is how i created the excel first: Create instance > Create Workbook > Activate Workbook > Save WorkBook as ( this has 3 parameters (handle, workbook name and file...
  4. M

    Process stuck on "Excel is waiting for an OLE action to finish" when executing macro

    Hi guys, I have a process scheduled to run every 30 min which uses a macro to query a SQL entry from database. Yesterday I got unexpectedly an error "Excel is waiting for an OLE action to finish" From what I googled it looks like "Object Linking and Embedding action" is pending with another...
  5. M

    Open Workbook (Excel) can't open it because of Exception (see below the details)

    Thats the message what i get if i am starting my process. I attached also a screenshot. Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. Please help me out by that problem! Thank you very much.
  6. V

    Excel VBO unlock worksheet

    I am currently looking for a VBO to unlock worksheets in a Excel file. I found the lock workbook vbo and tried to amend it for the worksheet lock function but could not seem to do so. Does someone have such a VBO and could help me (especially with the code part). Thank you in advance
  7. B

    How do I store an image into an image data item instead of manually importing it in Blue Prism? I need to automate it.

    I am Using Google Vision API to extract some data from some images. But the problem is that I need to manually import and assign the image file each time in the image data item for each time. How to get the image data item get automatically assigned by image path or something like that. Please...
  8. S

    excel VBO

    Hello guys, I'll explain my scenario and Problem, can you suggest me few options? scenario: I've data in my excel sheet and the corresponding pie chart on the same sheet. Example Data as follows Asset Type Amount Savings $ 25,000 401k $ 55,000 Stocks $ 15,000...
  9. G

    Solved Error: net_io_connectionclosed in Email VBO

    Hi, I am trying to send an excel file as an attachment using Email VBO, but I am getting this error(below snapshot). All the collections are getting populated, my guess is it related to something syntactic. Please advise.
Top