Convert excel file 2010(64 bit) to 2003

Tyberian1988 · #1 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert a text file to an Excel file with the data format automatically?	mradmin	Excel	6	10-16-2013 10:34 AM
Use 2003 template in 2010 file	kenelder	PowerPoint	1	08-30-2012 12:22 PM
saving data in excel 2010 from excel 2003	johnkcalg	Excel	1	02-06-2012 07:33 PM
Going from Outlook 2003 to 2010, can't export the pst file	Ckingfly	Outlook	2	07-10-2011 10:03 PM
Excel add-in 2003-2010	Danny	Excel	0	07-05-2011 03:37 AM