+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Making an 2003 document with VB and macro's compatible with 2007

  1. #1
    Registered User
    Join Date
    04-09-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Making an 2003 document with VB and macro's compatible with 2007

    Hi Guys

    I have a spreadsheet set up in Excel 2003 which uses VB and macro's however I now have some people who have Excel 2007 and the form no longer works.

    Is there any quick way to make this document compatible with Excel 2007 without re-building it from scratch?

    Thanks

    Darren

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Making an 2003 document with VB and macro's compatible with 2007

    Without seeing the workbook or knowing what "no longer works" means it's hard to say.

    Do the xl2007 users even have macros enabled?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-21-2009
    Location
    New York City
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Making an 2003 document with VB and macro's compatible with 2007

    I have the same problem. VBA is installed. But excel 2007 cannot use my add-in from earlier versions of excel. (C'mon microsoft, isn't that part of forward compatibilty?) The error messages direct me to microsoft.com to search for a vba converter. I have searched, and searched, but cannot find it. There is something that looks close but is for Macintosh only.

+ 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