Search results

  1. R

    Reading a Table from Word, Reading a untitled notepad

    It worked. Thanks a lot but doesn't work when columns in word document table are merged :(
  2. R

    Working with MS Word

    It worked but not when columns are merged.
  3. R

    Working with MS Word

    Thanks. Any idea on the other points as well? :)
  4. R

    Reading a Table from Word, Reading a untitled notepad

    Thanks .i will try and update you by tomorrow
  5. R

    Working with MS Word

    I need to perform the below in MS Word.. any easy way/ code stage to perform these steps directly ? 1. Fetch table from word to excel based on table number . 2. Search for table using the header information 3. Delete text from a particular point Upto the next section in Word . 4. Delete a given...
  6. R

    Reading a Table from Word, Reading a untitled notepad

    word VBO doesn't have Get table option. Any code which can be used to get any of the tables from Word simply by providing the table number? Also, can we not search text >255 characters in word document ? The inbuilt action "Find Text" workd with only <255 characters in string for performing a...
  7. R

    How to delete columns in a collection

    How do I delete and empty column. Catch is that I don't know the column or columns which might be empty in collection. Is there a way to do it without knowing the column name ??
  8. R

    RUN macro button in excel not spyable

    Awesome . Thanks ..
  9. R

    RUN macro button in excel not spyable

    I have a client macro (locked) which has run macro button . I can't spy it and don't even know yet how to run it using run macro action in BP since the code is locked. Even if I get the macro name then I am afraid that BP can get stuck indefinitely if any pop up appears when macro runs. How to...
  10. R

    Opening password protected excel file with a readonly pop up

    its fixed through a code stage. Thanks for the help.
  11. R

    TAG Filter on work queue

    Hi VJR, on your previous response to the below I have a query. Scenario 1: "+TAG1;-TAG2;+TAG3;+TAG4" This will not match the blank (untagged) rows. This is because Blue Prism treats these as "AND" condition and not "OR" condition. Is there a way we can filter tag based on OR criteria ...
  12. R

    Unprotect Workbook

    link doesn't open at my end. I tried the below. Dim wb as Object = GetInstance(handle).Workbooks.Open(Filename:=filename, Password:=password) name = wb.Name wb.Activate() used a copy of open workbook action and added input parameter password in input. Code runs fine but the file is not opened...
  13. R

    Opening password protected excel file with a readonly pop up

    There is a timeout error at Open WB stage only because of the password pop up. How to resolve that? I only need to open a password protected Workbook.
  14. R

    Unprotect Workbook

    i need to open a protected workbook. Lets say my excel name is abc.xlsx and opens with password 1234. I need a way to open this with BP using code. Any inputs, please share the exact details.
  15. R

    RPC_E_Disconnect error

    anyone.. any inputs that can fix this issue. thread pending since long.
  16. R

    How to get value of ID (from control room) in BP

    Say if multiple bots are running and some processes got terminated due to some exception . Then I am triggering a mail to user with exception details. For backtracking and debugging by the developer, I want that the mail should also contain that ID (first column in control room) so that...
  17. R

    How to get value of ID (from control room) in BP

    Hi, In control room there is a column named ID which is a random number for a process when executed on a resource pc. How can we get the value of that ID in BP ? I tried using get Seasion id but it is fetching an encrypted value..
  18. R

    Writting a backslash (\) and any other special character

    Try forward slash pls once.
  19. R

    Wait stage is not working

    Good observation VJR. Even DOB is being provided using navigate stage. Not sure why. Bhuvan.sundar - pls check Also, dynamic wait should work in this case. Pls try the approach suggested by VJR. Regarding the online videos - I don't have any link but some videos are really popular on YouTube...
Top