+ Reply to Thread
Results 1 to 6 of 6

2003 to 2007 Macro conversion

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    Houston TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    2003 to 2007 Macro conversion

    Hey guys

    I am new to macro coding this code was written with 2003 but everytime I try to run these same macros with excel 2007 I get an error messaging about converting the file to a different version. Is there any quick fix for this? Here are the macros

    '
    Selection.Copy
    Sheets("MACRO").Select
    Rows("1:1").Select
    ActiveSheet.Paste
    Range("H1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("G16").Select
    ActiveSheet.Paste
    Range("E1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("G17").Select
    ActiveSheet.Paste
    Range("F1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H17").Select
    ActiveSheet.Paste
    Range("I1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H18").Select
    ActiveSheet.Paste
    Range("A1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("G19").Select
    ActiveSheet.Paste
    Range("C1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H19").Select
    ActiveSheet.Paste
    Range("D1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H20").Select
    ActiveSheet.Paste
    Range("H20").Select
    End Sub
    Sub PACKLABEL()
    '
    ' PACKLABEL Macro
    ' Macro recorded 9/7/2001 by Jaynew
    '

    '
    Selection.Copy
    Sheets("MACRO").Select
    Range("A1").Select
    ActiveSheet.Paste
    Range("H1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("G25").Select
    ActiveSheet.Paste
    Range("I1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H26").Select
    ActiveSheet.Paste
    Range("A1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("G27").Select
    ActiveSheet.Paste
    Range("C1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("H27").Select
    ActiveSheet.Paste
    Range("G25").Select
    End Sub

  2. #2
    Registered User
    Join Date
    06-19-2012
    Location
    Canada Eh
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    40

    Re: 2003 to 2007 Macro conversion

    I don't see why there should be a problem with your code. Did you try Save As an xlsm and then run the code?
    EF killed Mordred

    46 & 2 is just ahead of me!

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,495

    Re: 2003 to 2007 Macro conversion

    Please read the forum rules and add code tags to your code excerpt before anyone can help you.

    Whilst you're at it, it would be helpful to post a sample workbook. I have Excel 2003 and 2007 so I can probably see the issue first hand. But, even if I know what to do, I can't tell you unless you sort those code tags.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    07-12-2012
    Location
    Houston TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: 2003 to 2007 Macro conversion

    yep. still nothing

  5. #5
    Registered User
    Join Date
    07-12-2012
    Location
    Houston TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: 2003 to 2007 Macro conversion

    ok give me a second, sorry

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,495

    Re: 2003 to 2007 Macro conversion

    Repeating the code without the description of the problem isn't going to help.

    Please read the forum rules.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1