Recent content by LeoLugo

  1. L

    Need Help! Filtering PivotTable Error HRESULT: 0x80070057 (E_INVALIDARG))

    excel.ActiveSheet.PivotTables(PivotName).PivotFields(PivotField).PivotFilters.Add(Type:=12,Value1:=value) Try this
  2. L

    Filter Excel Column Value Having Multiple Values in the cell

    Not 100% sure but I think you will have to write some code using the AutoFilter method
  3. L

    Replace Values in Word using values from Excel.

    If your document is just a regular document the Find action should work I have no idea why it wouldn't work for you.
  4. L

    Firefox or Chrome Navigate Action

    Check out this thread.
  5. L

    date format

    AddDays(FormatDate(Today(), "ddd, d MMM, yyyy"), 2)
  6. L

    MS Access Operation

    Your question is very vague but you can try using the Blue Prism "Data - OLEDB" business object. Open up an action, select the "Data - OLEDB" object then click the blue information icon. Read the docs. It's pretty easy to use. If you get stuck with the connection string take a look at this.
  7. L

    Navigate URL in BP object studio

    If your version of BP works with Chrome you can do what I did. 1. I passed the destination URL from the process down to the Object 2. In the Launch action I provided the destination URL in the "CommandLineParams" input. This will cause Chrome to navigate to the provided url when first opened...
  8. L

    Urgent Chrome doenst work proper

    Not exactly sure if this helps your situation but the release notes from BP 6.6 in the updates says something along the lines of: Blue Prism was unable to interact with Chrome or Firefox when processes launched a locally installed application followed by a browser-based application. This issue...
  9. L

    Build a BOT to take the list of available resources.

    This post might be able to help. Not 100% sure though.
  10. L

    Build a BOT to take the list of available resources.

    Not sure if this will help or not but there is a url you can enter into your local browser when BP is running that will return the resources and their current status. I can't remember it off hand but if this makes sense at least you can head in the right direction
  11. L

    Internal : A token must be provided to release a lock

    I don't remember the exact action name for sure but, when you first get a lock it outputs a token which should be saved locally. When attempting to release the lock you need to provide that token as an input to the release lock action. I would check and make sure that is being done correctly.
  12. L

    Password not being recognised when typed by bot

    Okay. From what I understand you should always try Global Send Keys first. Events are only supposed to be used as a last resort
  13. L

    Password not being recognised when typed by bot

    By any chance did you Activate Application before using Global Send Keys? This is done to make sure the keys are being sent to the correct application. If this doesn't work can you tell us exactly what happens when you use Global Send Keys?
  14. L

    Collection Manipulation

    If you need help can you post screenshots please?
  15. L

    How to use set data action

    The "Get Next Item" Action should have an output of "Item ID". This is the text the you will place in the "Set Data" Action input of "Item ID".
Top