Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Download program's forms does not appear and run (Excel 2000)

    Hans and all,

    I have download a program from home's PC, bring it to my office and paste it. I have no problem of running it at home but however, some function and all forms does not appear when I open it in the office. It show me : Complie error : Can;t find project or library.
    I have attached a part of the code here.

    Pls advise how can I have this program open with forms and run normally.

    thanks, kun

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Download program's forms does not appear and run (Excel 2000)

    Activate the Visual Basic Editor (Alt+F11)
    Select Tools | References...
    If you see one or more references that start with MISSING, note which ones they are, then clear their check boxes and click OK.
    Select Debug | Compile VBAProject to see if the code is OK now.
    If it isn't, you'll have to set the appropriate references in Tools | References...
    Post back with details about the MISSING references if you don't know what they are for.

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Download program's forms does not appear and run (Excel 2000)

    Hans,

    see attached, Why does it show A drive?? I have save it in my C drive. I try save it under .xla and move in to addin folder but Excel was unable to start. However, in my home PC, it is fine.

    What would you suggest that I do with this program

    thanks, kun

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Download program's forms does not appear and run (Excel 2000)

    I can't tell from those screenshots. See Jan Karel Pieterse's Create Addins article for information about add-ins.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •