Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-10-2014, 10:49 PM
Tyberian1988 Tyberian1988 is offline Convert excel file 2010(64 bit) to 2003 Windows 7 64bit Convert excel file 2010(64 bit) to 2003 Office 2010 64bit
Novice
Convert excel file 2010(64 bit) to 2003
 
Join Date: Mar 2014
Posts: 3
Tyberian1988 is on a distinguished road
Question Convert excel file 2010(64 bit) to 2003

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert excel file 2010(64 bit) to 2003 How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM
Convert excel file 2010(64 bit) to 2003 Use 2003 template in 2010 file kenelder PowerPoint 1 08-30-2012 12:22 PM
Convert excel file 2010(64 bit) to 2003 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft