Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Apply filter

Anonymous
Not applicable

‎01-06-17 01:53 PM

Hi there, Apply filter in MS Excel VBO-Extended often doesn't work properly. Sometimes it can be fixed by rebooting PC itself. It would be appreciated if you have any usuful code or any idea to improve the function.
0 Likes
2 REPLIES 2

TomBlackburn1
Level 7

‎02-06-17 02:08 PM

Hi Naohrio, I don't believe that MS Excel VBO-Extended is an official Blue Prism offered VBO. I of course could be wrong (would be interested in the VBO if it is official). There are various type of filters that you can apply in excel. Ones that apply multiple criteria to a single column based on collection input, those that span multiple columns etc. Can you include the code stage content here and I may be able to help. Tom
0 Likes

JivankumarKedar
Level 3

‎04-12-17 02:25 PM

You can use OLEDB vbo for this. Apply filter in the form of SQL query and export the collection. Then write this collection to file
0 Likes