+ Reply to Thread
Results 1 to 3 of 3

Compile error with windows 7 and 8.1 VBA commands work in XP.

  1. #1
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Compile error with windows 7 and 8.1 VBA commands work in XP.

    I have some coding that works well with Excel 2010 on windows XP. Just tried the following code on windows 7 and 8.1. Coming up with Compile error. Can't find project or Library.

    The attached code seems to crash at the Left Command. If I delete that portion then it does not recognize fdlr. Any thoughts how to bring this code to be compatible with Windows 8.1

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Compile error with windows 7 and 8.1 VBA commands work in XP.

    Hi Epscan,

    Remove any references from the Visual Basic Editor (Tools > References) that start with MISSING: and reselect them from the Available References list if necessary.

    HTH

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Re: Compile error with windows 7 and 8.1 VBA commands work in XP.

    Hi Robert

    Thankyou!

    Found that I was missing Microsoft calendar control 11.0. Which is interesting because as far as I know I am not using it for anything in my code.

    Unchecked and saved. Everything seems to be working at the moment.
    Will do more testing tomorrow.

    Most of my code has been written for Office 2007.
    I had added the mscomct2.ocx file but if I continue to have problems on future workbooks I will add the mscal.ocx.

    http://answers.microsoft.com/en-us/o...9-e757223ebdde
    Last edited by Epscan; 11-11-2014 at 10:01 AM. Reason: Added Thankyou

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compile error in hidden moule: The work book
    By praveenkumaranne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2014, 10:22 AM
  2. [SOLVED] Compile error: Can't find project or library - Windows 7 64 bit
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2013, 04:15 AM
  3. [SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  4. [SOLVED] Compile Error: Can't find project or library. Windows vs MAC issue?
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2013, 05:40 PM
  5. Getting this code to work on MAC (ERROR 68) - works fine on Windows
    By LT1511 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2012, 11:09 PM

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