Closed Thread
Results 1 to 4 of 4

Can’t find Project or Library

  1. #1
    Registered User
    Join Date
    04-26-2007
    Posts
    77

    Can’t find Project or Library

    Dear Experts.

    When I run my excel file on some other computer, it displays following error message

    Can’t find Project or Library

    Then cursor stops on word Format
    Date1=Format(now,”dd-mm-yy”)

    On my personal computer the Regional setting is “dd-mm-yy”
    May Date setting is different on other computer.

    My question are:
    1- How to overcome this problem?
    2- How to automatically change Control Panel’s Regional and Language Options through Excel codes?

    I wan to add some module to change Date setting to “dd-mm-yy” on every computer onwhich the excel file will execute.

    Thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    This error message often causes confusion. It appears if a reference in the workbook is missing.

    Try hitting TOOLS-REFERENCES in the VBA editor and seeing if any of the references have a missing flag against them.
    Martin

  3. #3
    Registered User
    Join Date
    04-26-2007
    Posts
    77
    Please read this agian

    Quote Originally Posted by tqm1
    Then cursor stops on word Format
    Date1=Format(now,”dd-mm-yy”)

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Although it might sound strange, the original solution should be checked. The line that is highlighted may not actually contain an error.

Closed Thread

Thread Information

Users Browsing this Thread

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

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