Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

VBA Macros complient on different computers

  • 15-12-2008 11:30pm
    #1
    Peter B
    Registered Users, Registered Users 2 Posts: 1,086 ✭✭✭


    I have build a VBA macro at home which I want to use at work. It works fine on my computer. I have built it using Excels VBA editor. It opens and closes different Word files as well as completing a number of simple tasks. I have built the macro using Excel 2007 and am trying to run it on my work computer using Excel 2000 - 2003. I get the error below

    "Cannot find Project or Library"

    Is there an easy to way to guarantee my Macros will be compliant and work properly on both versions of Excel / Office?

    Any help???:confused:


Comments

  • #2
    KStaford
    Closed Accounts Posts: 815 ✭✭✭KStaford


    would need to debug that to see which library its looking for. You might try building the macro(s) in the older version of the software and then try running it on the newer version (backwards compatability).


  • #3
    mark.leonard
    Registered Users, Registered Users 2 Posts: 2,084 ✭✭✭mark.leonard


    Peter B wrote: »
    I have build a VBA macro at home which I want to use at work. It works fine on my computer. I have built it using Excels VBA editor. It opens and closes different Word files as well as completing a number of simple tasks. I have built the macro using Excel 2007 and am trying to run it on my work computer using Excel 2000 - 2003. I get the error below

    "Cannot find Project or Library"

    Is there an easy to way to guarantee my Macros will be compliant and work properly on both versions of Excel / Office?

    Any help???:confused:

    Stick up the code its complaining about and we might be able to help more.


Advertisement