+ Reply to Thread
Results 1 to 4 of 4

VBA Macro not upwards compatible from Excel 2007 to Excel 2010

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    55

    Question VBA Macro not upwards compatible from Excel 2007 to Excel 2010

    Have an Excel 2007 Macro that I have not converted from Excel 2007 to Excel 2010 because it is not upwards compatible. I tested it in 2010 and I get all kinds of VBA coding errors but it works fine in 2007. How do I resolve these coding errors. Has anyone else come across this problem. We cannot move to 2010 until I resolve this problem. Any advise would be very helpful.
    cmwilbur

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: VBA Macro not upwards compatible from Excel 2007 to Excel 2010

    In the dark, here. How about posting some of the code... How about describing some of those all sorts of errors...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    06-11-2010
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: VBA Macro not upwards compatible from Excel 2007 to Excel 2010

    Will run it on my coworker's machine in morning to get errors.

  4. #4
    Registered User
    Join Date
    06-11-2010
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: VBA Macro not upwards compatible from Excel 2007 to Excel 2010

    We resolved the problem with the VBA Macro not being upwards compatible - this is what we did to fix it. Too much info to write here so we created a Word document to list the issues.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-10-2014, 12:11 PM
  2. Are Excel 2010 files compatible with Mac Excel 2011?
    By FlyUK in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 06-03-2013, 04:00 PM
  3. Macro created in excel 2010 and compatible with excel 2003.
    By Tinong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2013, 11:24 AM
  4. [SOLVED] Repeat All Item Label in Excel 2007 -- Need Macro to do what Excel 2010 can do
    By PaulLor89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2013, 01:29 PM
  5. Macro from excel 2007 doesn't work in excel 2010
    By maddozs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2013, 04:57 AM

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