Search results

Hi Madhu, To handle this situation only we have Environmental Locks. If we open a excel file in a shared path, while an another person tries to open at the same time ,a pop up will be getting that the other person has opened the excel file. Better we can use environmental locks action in...

Try with Decision Stage , use AND operator. eg: InStr(Trim([test]), "ASR")<>0 AND InStr(Trim([test]), "WEEA")<>0 AND InStr(Trim([test]), "COMBO")=0

Can you share the code

I'm getting a string with dynamic value which have a numeric digit. I need to extract it. Please help to do in single stage or in code stage.

I need to write the collection value to excel, How copy paste works in this.. I didn't get. Can you give the specific VBO and action

If you using MS excel VBO, then date will be getting as text. Using Select Query , it can give the exact datatype what the filed is having in excel. eg- "SELECT * FROM [SheetName$] WHERE [ColumnName]='***'"

Hi Mwacuka, I have used Queries to handle around 50000 datas in excel. Instead of using MS excel VBO, i have tried with OLEDB,

Thanks for your response. The issue is solved by using "SELECT distinct[Columnname] FROM [Sheetname$] "

Try using OLEDB. Use select query. SO u can get the exact value of Excel in Collection

Hi, I have a collection having 85,000 values. i need to write the collection to a excel.I used Write collection of excel VBO, BP itself hanged . Please give a solution to export the collection into a excel file. Please Help me in this.

Hi Otonx, I have tried but in OLEDB, it shows too many parameters matching.

Hi, Since my Excel is having 50,000 Values. I am taking to DB and Fetch the Value. I just need a single column value which should avoid duplicate values. I am trying using Distinct Option. But unable to fetch it. Please Help me in this.