Compile Error : cannot find project or property

  • Hi I have tried running my project to another computer both are using excel 2013. When I run the project on my laptop it works fine however when I try to run it in my friend's laptop it gives the compile error : Cannot find Project or Property.
    [ATTACH=CONFIG]68921[/ATTACH][ATTACH=CONFIG]68922[/ATTACH]
    This happens when the code in my thisworkbook (alerts the expired dates, see code below)


    runs upon login and it displays a reference dialogue box after clicking ok. Then the word date is highlighted. I don't know if i should click/tick one of the choices and i don't know which one to tick. Does my friend need to install a missing library? Thank you in advance

  • Re: Compile Error : cannot find project or property


    Simple when you actually read the error message. Outlook is not installed on the machine. The code references Outlook so will always give the compile error and will always error later in the code.


    Solution: Install Outlook, or remove the reference to Outlook rewrite the code to suit.

  • Re: Compile Error : cannot find project or property


    outlook is the only thing i need to install? Great!! ill try the outlook first coz i don't really know how to not refer my codes to outlook I'm just starting to know the ins and out of VBA :) Thank you so much thats a big help ^_^

  • Re: Compile Error : cannot find project or property


    i tried to open the usb that i used to transfer my project to the other laptop it gave me the same error. but i checked my MS Office i have an outlook. but when i run the project saved in my HD it worked fine. im confused

  • Re: Compile Error : cannot find project or property


    Nothing in that message makes any sense.


    Quote

    i tried to open the usb that i used to transfer my project


    What does a USB drive have to do with anything?


    Quote

    when i run the project saved in my HD it worked fine


    Is that surprising?


    I'm sorry. I don't think I can help you. Your problem is nothing to do with code or Excel but you seem a little unsure of the basics of Windows.

  • Re: Compile Error : cannot find project or property


    sorry not that i dont know anything or unsure of the basics of windows i just got confused and worried why the program from the stick got the error of the other computer. anyhow thank your for u help i think i figured out how to solve my problem..