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...
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...
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 ??
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...
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 ...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.