[RESOLVED] Converting from BVA to VB6

[caleno]

Hi I need to convert the format of two columns in excel. Time and Date. I recorded a macro and this is the BVA code I get.

    Columns("B:B").Select
    Selection.NumberFormat = "h:mm;@"
    Columns("A:A").Select
    Selection.NumberFormat = "m/d/yy;@"

Now I need to convert it to VB6. Can you help me? I try it several times but I could not get it. See below

 'oXLsheet.Range(Columns).Select
    oXLsheet.Columns("B:B").Select
    oXLsheet.Columns.NumberFormat = "h:mm;@"  
    oXLsheet.Columns("A:A").Select    
    oXLsheet.Columns.NumberFormat = "m/d/yy;@"

Thanks