+ Reply to Thread
Results 1 to 6 of 6

Trying to run VBA ver10 macro on ver16

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2002
    Posts
    3

    Trying to run VBA ver10 macro on ver16

    Hello folks, can a version 16 machine run a version 10 macro somehow? Or do I have to convert the code to version 16 in some manner?

    Regards,

  2. #2
    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
    44,093

    Re: Trying to run VBA ver10 macro on ver16

    It would rather depend on what the macro does. Not enough information to give a definitive answer.
    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


  3. #3
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Trying to run VBA ver10 macro on ver16

    maybe (have to include more characters in response to post)
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  4. #4
    Registered User
    Join Date
    12-15-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2002
    Posts
    3

    Re: Trying to run VBA ver10 macro on ver16

    Thanks for the reply, I've got two sheets with raw data coming from the web, a dart league, and I'm sorting out the duplicates and blanks, removing graphics, and then taking the two pages and combining and sorting them. The sorts and everything else works fine in ver10, but go to 16 and there's errors.

    I've been working on it a bit since i last posted and went to Option explicit, cleaned up the declarations, and changed some of code to delete the graphics. Will have to wait for my buddy to run the program on ver 16 to report back.

    Is there other stuff I might be digging into?

    Cheers,

  5. #5
    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
    44,093

    Re: Trying to run VBA ver10 macro on ver16

    Check for missing references.

  6. #6
    Registered User
    Join Date
    12-15-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2002
    Posts
    3

    Re: Trying to run VBA ver10 macro on ver16

    Great, will do, thanks.

+ 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. [SOLVED] Macro to add another Macro to a button to add into a larger Macro.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2016, 10:51 AM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 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