SS&C Blue Prism Community

Ravikiran44 · 27-05-22

Hi All,I recorded a macro in excel to delimit the date format using following VB code,Dim excel as Object = GetInstance(handle)Range("B13").SelectRange(Selection, Selection.End(xlDown)).SelectActiveWindow.SmallScroll Down:=3Selection.TextToColumns De...

Ravikiran44 · 06-05-22

Hi , I want to freeze panes for a particular row in excel,Could any one have the code to achieve that.Thanks ,------------------------------Ravi kiran P------------------------------

Ravikiran44 · 28-04-22

Hi all,How hard is the Associate developer [ASDEV01] certification is & how should be the preparations,Please provide me some guidelinesThanks,------------------------------Ravi kiran P------------------------------

Ravikiran44 · 01-06-22

Hi Devneet,Yes, Need to delimit the date as it contains space on the right side and not able to to convert that date into any format i.e MM/DD/YY,without delimiting not able to format the particular cell .------------------------------Ravi kiran P---...

Ravikiran44 · 01-06-22

Hi Devneet,I tried executing but delimiting is not happening to the cells or do we have any other code stage to delimit the date format.Below is the screenshot,Thank you,------------------------------Ravi kiran P------------------------------

Ravikiran44 · 06-05-22

Hi Rick,Could you please provide me the code to freeze a particular row in excel using code stage.Thanks------------------------------Ravi kiran P------------------------------

SS&C Blue Prism Community

User Statistics

User Activity

Method arguments must be enclosed in parentheses

Freeze panes

ASDEV01 Certification

RE: Method arguments must be enclosed in parentheses

RE: Method arguments must be enclosed in parentheses

RE: i was lucky to get the code