+ Reply to Thread
Results 1 to 10 of 10

Make the Macro Excel-2000 Compatible

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Make the Macro Excel-2000 Compatible

    I have an Excel Macro which is working fine in Excel 2003 or higher.

    But it is giving error at many places in Excel 2000. Also "Debug" button is not available when any error occurs.

    And the main problem is, I don't have Excel 2000. Only my client has.

    Please review the attached macro and suggest changes I need to do to make it Excel-2000 compatible.
    Macro.zip

    I'm really stuck with this problem since last few days. Please help. Thanks in advance!
    Last edited by Tejas.T; 10-21-2012 at 12:41 AM.

  2. #2
    Registered User
    Join Date
    10-20-2012
    Location
    italy
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Make the Macro Excel-2000 Compatible

    Hi,

    I still have version 2000
    I run it on another copy of the two macros.
    I tested without changing the code, and I disabled the lines of code that are not available in Excel 2000
    Note, in the VBA editor has disabled the rows with the comment: Hidden
    Attached Files Attached Files

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Make the Macro Excel-2000 Compatible

    Hi, tejastanna77,

    Module1
    Please Login or Register  to view this content.
    Module1
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    All these lines rely on changes to the colour sysstem introduced with Excel2007 and are not available in Excel prior to Excel2007 except the Compatibility/Conversion Pack from MS is installed (MS recommends to only use it with Excel2003 as that version has shown a couple of features not available in the older versions).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Make the Macro Excel-2000 Compatible

    Hi PcSaggio,

    Thanks a ton for your efforts. I will send the updated macro to client asap.

    BTW can you please confirm you have tested the updated code in Excel 2000 and it's working fine?

    Thank you again
    Last edited by Tejas.T; 10-21-2012 at 06:06 AM.

  5. #5
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Make the Macro Excel-2000 Compatible

    Hi HaHoBe,

    Thank you for your correct suggestion.

    BTW did you find any other code which may not work in earlier version?

    If you have office 2000, I request you to run the macro in it. Code which is used is Tejas_NewCode function in Module2.

    Thanks again.

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Make the Macro Excel-2000 Compatible

    Hi, tejastanna77,

    Please Login or Register  to view this content.
    Colored tabs where introduced with Excel2002/XP, not available in Excel2000.

    Maybe you should work a bit on the code and avoid Select and Activate. Sample:
    Please Login or Register  to view this content.
    with something like
    Please Login or Register  to view this content.
    You set Objects (like shown above) that you do not use afterwards, you employ macro recorder based code which is reworked but could be made more efficient with just small work on it (which would reduce running time of the procedure as well as stability and even more readability of code). And maybe you should have a look at the Reddick Naming Conventions - I would not expect reP to be the object of a worksheet while wsRep would indicate that to me.

    Ciao,
    Holger

  7. #7
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Make the Macro Excel-2000 Compatible

    Hi HaHoBe,

    Thank you for your valuable suggestion. I have made that change in my code.

    BTW what do you think about

    Please Login or Register  to view this content.
    Will it work?

    Besides that, can you please suggest any more enhancement in the code?

    Thanks you again

  8. #8
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Make the Macro Excel-2000 Compatible

    And is it working fine your Excel 2000?

    Can you PLEASE check it out if possible? As I am going to deliver it to client today. I don't have Excel 2000 setup.

    Thanks in advance

  9. #9
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Make the Macro Excel-2000 Compatible

    Hi, tejastanna77,

    I missed the Tabs-things by just looking at the code. The Debugger didnīt find anything but by stepping through the code with F8 this line was highlighted. There were no other errors reported on the first run.

    I posted my thoughts on "working fine" before - you should add a check for the sheetnames to be inserted (deleting the ones which do not have a unique name or at least ask the user whether to delete or to end the macro). There is absolutely no error handling in that code - I wouldnīt consider that to be anywhere near to get into anybody elses hands except mine as programmer to thoroughly rework the code (my 2c on that, and donīt mean me, HaHoBe, as the programmer to make that clear).

    Ciao,
    Holger

  10. #10
    Forum Contributor
    Join Date
    10-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Make the Macro Excel-2000 Compatible

    Ya true.

    I will put On Error GoTo [Block-Name] in my code.

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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