Search results

  1. M

    How to set Initial Values of a collection from excel file?

    Hello my friend, no I didn't. I have excel spreadsheets for this purpose which I load to empty collections. It should work for everything.
  2. M

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

    hi sivagelli, thanks for your response. in a fact I'm already trying to call the SQL query via an internal object which uses timeout so let's hope that will work.
  3. 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...
  4. M

    Work Queues - Get exception items to collection with all the columns (without loop)

    Hi guys, any idea how to get exception items from queue to collection without using loop? There is a "Get Exception Items" action with Work Queue object but it saves only item ID to collection, not all the columns. Thx
  5. M

    How to set Initial Values of a collection from excel file?

    Hi VJ, that is exactly the problem - that I have to manually put 300 countries there. And have another big collection where I also need to have the data as initial values. And I'm not sure what do you mean that Current values become Initial values when I start the process? I don't see anything...
  6. M

    How to set Initial Values of a collection from excel file?

    Hi guys, this seems pretty basic but can't find solution for this anywhere. What I need is a fixed collection with list of countries and country codes which I have in xls but need to have it in BP collection as initial values. Of course I know how to Get Worksheet as collection but this will...
  7. M

    How to Convert Excel to PDF using Blueprism

    Hi, have you already solved this? I have the same problem. I created a separate object where I copied "Save Workbook As" stage from MS Excel VBO and used following code from the video instead of the original one: Dim wb as Object = GetWorkbook(handle,workbookname) Dim excel as...
  8. M

    Can't send Global Mouse Click Center to option button when spied via AA mode - ony "verify" action possible in Navigate stage

    Hi all, I'm having problem with spying the option button in Mozilla - when I spy it via AA mode there are no actions available in Navigate stage other than "Verify" When I try to spy it via UI mode BluePrism it works fine but sometimes BluePrism can't find it - it is looking for the button...
Top