Microsoft Office Forums - View Single Post - [Solved] Convert excel file 2010(64 bit) to 2003

Tyberian1988 · 03-10-2014, 10:49 PM

Hello! I have a file.xlsm (created in excel 2010, 64 bit) and i need to run it with excel 2003.The problem is with the VBA code.When i click the command buttons on my sheet i recive msg box with error: "Run-time error '13' : Type mismatch"
Debug:

Code:

Sub Procedure7()
 Sheets("CS EXL").Columns("A:B").Copy Sheets("Sheet1").Range("B:C")
End Sub

For the next command button i revice : "Run-time error '438':Object doesn't support this property or method"
Debug:

Code:

Private Sub SpinButton1_SpinDown()
Sheet1.Unprotect Password:=""
i = 28
Columns("Ac:Ag").Select
    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    Selection.Borders(xlEdgeLeft).LineStyle = xlNone
    Selection.Borders(xlEdgeTop).LineStyle = xlNone
    Selection.Borders(xlEdgeBottom).LineStyle = xlNone
    Selection.Borders(xlEdgeRight).LineStyle = xlNone
    Selection.Borders(xlInsideVertical).LineStyle = xlNone
    Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    With Selection.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    Sheet1.Protect Password:=""
End Sub