Search results

  1. F

    Get last item from queue with a specific tag

    Hi, In my queue, i have 1000 items with different tags associated. See below for sample data: Item1 - tag1 Item2 - tag1 Item3 - tag2 Item4 - tag1 Item5 - tag2 Item6 - tag3 Item7 - tag1 Item8 - tag3 Item9 - tag2 Item10 - tag3 In this case, i need only the items with tag1, which i can get using...
  2. F

    Input Output parameters in two different processes

    Thanks VJR. Is it good practice ?
  3. F

    Input Output parameters in two different processes

    Hi I have process 1 in which I need two parameter(output) which I will use in process 2 as an input. Is it possible to use input output parameters in 2 different processes? Thanks, Falua
  4. F

    [Blueprism] Code stage to paste data as values in excel

    Hi, I have to copy some values from an excel sheet and paste them in another excel sheet of a different workbook. The original action "Copy and Paste Worksheet Range" in the MS Excel VBO object does not allow me to paste values only. I have duplicated the code stage for the action "Copy and...
  5. F

    Empty Check in Data Item (using decision stage)

    Thanks VJ, it worked. Regards, Falua
  6. F

    Empty Check in Data Item (using decision stage)

    Hi, I need to check if a data item (format: number) is empty in a decision stage, or convert the data item format number to text as the empty check is working with a data item formatted in text. I'll be grateful if I can get a solution to this problem. Thanks, Falua
  7. F

    Opening password protected excel file with a readonly pop up

    Thanks VJ, My issue is resolved. The actual problem was more technical. Since my 'Create instance' action and my 'Unprotect workbook' action were in separate objects, i got those internal errors. The main thing is use all actions from same object when you interact with Excel. All the...
  8. F

    Opening password protected excel file with a readonly pop up

    Hi again VJ, These are dummy data that i have tried to populate in the data items. The workbook/filename exists on the local computer and works till i am trying to unprotect the workbook. Input of the action Unprotect workbook : Thanks, Falua
  9. F

    Opening password protected excel file with a readonly pop up

    I have already pasted the code stage for the unprotect workbook. please find below the stages which i am trying to do:
  10. F

    Opening password protected excel file with a readonly pop up

    I removed the parameters, but i am still getting the error: Please help. Thanks, Falua.
  11. F

    Opening password protected excel file with a readonly pop up

    Hi VJR, Thanks for the solution. I am getting the error below while trying the solution: "The given key was not present in the dictionary." Can you please help in debugging? Thanks, Falua.
  12. F

    Opening password protected excel file with a readonly pop up

    Thanks VJR, My next issue is with the password. Since my worksheet is protected, I have to unprotect the worksheet by: 1. clicking on the highlighted in blue option 2. Entering a specific password, then unhide some tabs in the excel file. Do you have any idea on how to proceed? Thanks...
  13. F

    Opening password protected excel file with a readonly pop up

    Hi VJR, As a summary, I managed to make the coding part work for the readonly popup by adding "IgnoreReadOnlyRecommended:=True" to the Open workbook statement as follows: In order to test that the VBO is working as expected, this is what i have tried: Thanks, Falua.
  14. F

    Opening password protected excel file with a readonly pop up

    Hi Guys, When i double click on my excel macro-enabled file, there is a pop up which is generated which asks whether to open the excel file in a readonly mode or not. I should click on the 'No' option. I tried to code the action by duplicating the MS Excel VBO- Open Workbook object and...
Top