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

macropod · #2 03-10-2014, 11:39 PM

I have no problem with your Procedure7 sub in Excel 2003, but using an xlsm file in Excel 2003 may cause it to try to copy the entire column which, in that format, is far more than Excel 2003 can handle.

As for the second error, simply delete the offending line.

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