Questions

Excel97-Excel2007 Macro

+
0 Votes
Locked

Excel97-Excel2007 Macro

tflannery
Is there an easy way to convert a macro from Excel 97 to Excel 2007? We have many accounting accrual formulas that was in an old ancient Lotus Notes version which was then morphed into Excel97. The 2 users run this old version of Excel from our server. It needs to go.
  • +
    0 Votes
    Tig2

    You will have to re-write your macros. Already had to face this down going from Office XP to 2003.

    You might try to drag them in to Open Office Calc and then save them in current .xls format. In general, my Excel macros have worked fine in Calc. This isn't a guarantee, just my experience. You can find Open Office at http://www.openoffice.org.

    Good luck!

    +
    0 Votes
    ManiacMan

    I'm not a heavy user of Excel, but it is a bummer if you can't port your old Macros over to new versions of Office without requiring a complete recode job. Oh well, it is what it is.

    +
    0 Votes
    ThumbsUp2

    Excel 2007 is so different, you can't even downconvert the macros. It's in its own little world.

    On a side not though, SOME of the older simple macros will convert. Not very many though, so it technically needs a rewrite anyway. Had they gone from 97, converted to 2000, then converted to 2002, then 2003, then 2007, there would be less rewriting, but it still would be needed. Now, can you guess why many businesses haven't upgraded yet and have NO plans to do so?

    +
    0 Votes
    ManiacMan

    And MS is shocked to find that many corps are slow to adopt new versions? This is the reason why...too much work involved to recode everything.

  • +
    0 Votes
    Tig2

    You will have to re-write your macros. Already had to face this down going from Office XP to 2003.

    You might try to drag them in to Open Office Calc and then save them in current .xls format. In general, my Excel macros have worked fine in Calc. This isn't a guarantee, just my experience. You can find Open Office at http://www.openoffice.org.

    Good luck!

    +
    0 Votes
    ManiacMan

    I'm not a heavy user of Excel, but it is a bummer if you can't port your old Macros over to new versions of Office without requiring a complete recode job. Oh well, it is what it is.

    +
    0 Votes
    ThumbsUp2

    Excel 2007 is so different, you can't even downconvert the macros. It's in its own little world.

    On a side not though, SOME of the older simple macros will convert. Not very many though, so it technically needs a rewrite anyway. Had they gone from 97, converted to 2000, then converted to 2002, then 2003, then 2007, there would be less rewriting, but it still would be needed. Now, can you guess why many businesses haven't upgraded yet and have NO plans to do so?

    +
    0 Votes
    ManiacMan

    And MS is shocked to find that many corps are slow to adopt new versions? This is the reason why...too much work involved to recode everything.