+ Reply to Thread
Results 1 to 5 of 5

Need macro from Excel 2010 to work in Excel 2000

  1. #1
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Need macro from Excel 2010 to work in Excel 2000

    I am trying to get a macro to run correctly on Excel 2000. Currently it gives me an error. I am not sure what needs to be done as this isn't my code, rather something I found in response to my VP wanting to track versions.
    Code is attached below. I'm getting a compile error, "Sub or Function not defined"on the line [I]If FileExist(FolderPath & SaveName & SaveExt) = False Then[I] Which means I likely have the same problem with a similar line further down the macro.
    I assume that the issue is the FileExist as that doesn't seem to exist in Excel 2000 VBA. There is a FileExists but that doesn't solve the problem. I am unsure where to go from here to make this work in 2000. I just don't know enough to be able to resolve this one on my own.
    Any input or suggestions will be very gratefully accepted.
    Thanks,
    Bill

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need macro from Excel 2010 to work in Excel 2000

    It seems is missing the beginning of the macro...!
    Perhaps try next code , but it is difficult to check without Excel file
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Re: Need macro from Excel 2010 to work in Excel 2000

    My apologies, I have attached the complete code below. I am in the process of trying your code, will report back.
    Thanks much!
    Bill

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Re: Need macro from Excel 2010 to work in Excel 2000

    PCI,
    I tried your code. It complained about a couple of undefined variables and after I defined them it made it to the line " SaveName = myArray(0)" and it gave a "compile error, expected array" and highlighted "myarray". I know that this is part of my original code but really need some help getting this working
    I truly appreciate your help. I hope that you can help me get this working in 2000.
    Thanks much
    Bill
    Last edited by billfinnjr; 09-05-2018 at 07:35 AM.

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need macro from Excel 2010 to work in Excel 2000

    How did you define MyArray ?
    Please post the last code used with the update done

+ 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. Macro that works in Excel 2010 does not work in Excel 2013
    By karenmwhaley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2016, 08:12 PM
  2. [SOLVED] Excel 2003 Macro Won't work in Excel 2010
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2013, 06:42 AM
  3. Saved file from Excel 2000 to 2010 format and lost some Macro access
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-26-2013, 11:48 AM
  4. 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
  5. Excel 2003 macro won't work in Excel 2010
    By texan22 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-09-2012, 10:51 AM
  6. macro which works in excel 2000 does not work in excel 2002
    By nnayak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 09:17 AM
  7. Macro Excel 2000 do not work in Excel 2003
    By gilgil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 07:06 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