Recent content by viraj

Hi I'm trying some code to perform texttocolumn option to convert some dates in to a particular format.it doesn't give a error but but doesn't do the task.can you pls help me on this tia. Code Ws.Range(rng).TextToColumns(ws.Range("a1",1,1,false,true,false,false,false,false,"Array(1, 4),true)

Hi, I'm tring to split a string using Split Method using Assign activity in UIpath The VB code I have used to split doesn't working can any one help on this error Invoicedata.Split({"Arriving " , "Payment"}.StringSplitOptions,None) TIA

Hi Please check on below link http://www.rpaforum.net/threads/filter-excel-data-by-specific-criteria.992/post-4208

Yeah Thank you verry much

hi, Yeah But that one also didin't work

Hi VJR, Please Find the Attached this will be really helpful.

Hi Initially I have done the process for excel 2013 it doesn't has this error I tried with the Wild Cards but that also Doesn't Works and There will be multiple Workbooks open at a single time

Hi VJR I need to attach the WB for object studio but with this window title it cant be done Can you Help me on this. Thanks, Viraj.

Hi @VJR I get to work with excel 2016 and when I opened the workbook the window name comes like this way but when I opened it manually it comes as default I tried saving the workbook but it doesn't change the format can you help me to sort out this issue

Hi, Is there a way to make these vlookup Function Dynamic .

Hi, Can some one help me on way to get ANSI value for a letter in blueprism. Thanks, Viraj

Hi VJR, I was trying to Find and Select Cells with Specific text Using Below Code But It Gives Some Exceptions Can you Help Me on this, Dim wb as Object = GetWorkbook(handle,workbookname) Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname) wb.ws.Columns(1).Find(Text).Select

Hi, Did you put the input parameters

it works thanks again vjr

Thanks it really Helpful