Recent content by ravisankar

Hi satishnbtech Use Replace function Replace("Welcome to blue Prism", " ", "")

Thank you very much VJR.. it's working now with NamedRange.

Hi VJR, It is just column heading. I am not sure about NamedRange. How we can provide as a NamedRange? Can you please provide the inputs. Thank you.

Hi VJR, Still getting below error for this line of code: colname = ss.Range(ColumnName).Column. Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC Dim sw, ss As Object Dim excel, sheet, varUsedRange As Object Dim colname as Integer...

Hi VJR, I have ran after comment out all other bottom lines, but still getting this error. Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC I have removed Operator 7 and ran with below code, which is running fine...

Hi, It's not returning anything, as the line of code is giving error. Error: Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC Please suggest if any code changes are required.

Hi VJR, I have changed the code as below and ran, but still getting the below error. Dim colname as Integer colname = ss.Range(ColumnName).Column sheet.range(varUsedRange).AutoFilter (Field:=colname, Criteria1:=InputToSort, Operator:=7) Error: Internal : Could not execute code stage because...

If Field:=1, then getting output 'Dim colname as String 'colname = ss.Range(ColumnName).Column sheet.range(varUsedRange).AutoFilter (Field:=1, Criteria1:=InputToSort, Operator:=7) If mentioned as below, getting error. Dim colname as String colname = ss.Range(ColumnName).Column...

I want to filter the field 'PARENT" based on filter value "Ravi". ColumnName - PARENT InputToSort - Ravi Dim sw, ss As Object Dim excel, sheet, varUsedRange As Object sw = GetWorkbook(Handle, WorkBookName) ss = GetWorksheet(Handle, WorkBookName, WorkSheetName) sw.Activate() ss.Activate() excel...