Mid, Left, Right Function Macro Error

  • Hi there!


    I've got a little application in excel using macros.
    It worked perfectly with Excel 2000, but with Excel 2003 shows an error for every formula I've used in the macro -right, left, mid, date...


    Does anyone know how to fix it?


    THX in advance




    Please use code tags rather than color tags for code

  • Re: Error In Macro With Text Functions


    It's to do with the references you have defined and the order in which they are defined.


    Goto VBE->Tools->References and make sure:


    Visual Basic For Applications
    Microsoft Excel 9.0 Object library (or greater)
    Office 9.0
    OLE Automation


    Are checked.


    Regards


    Rich

  • Re: Error In Macro With Text Functions


    Thank you for your help.
    The problem was because of references as you noticed. Although it was the opposite. An external programm activated a library in the file, even if it wasn't necessary. Because of that some macros crashed whenever used in a PC without the external programm.


    Thanks again,
    Cereal

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!