Office 2010 - Left function


  1. Posts : 53
    W7
       #1

    Office 2010 - Left function


    I just opened an Office 2007 Excel project in 2010 which contains significant VBA. The compiler is puking at the Left function - Compile error - Can't find object or library

    I have tried retyping the line and also tried using the Right function, just to see what happened - and that was not accepted either!

    Earlier the compiler rejected the Ltrim function, but retyping the line seemed to solve it (It isn't halting the compiler anymore, but I have yet to test it).

    Any ideas?

    REAL worried at what else I am now going to run into, now that I "upgraded"...

    Great thanks for your thoughts, I have a feeling I am going to have many more questions due to the nature of the problems and upgrading...

    edit: I was wrong, it still pukes upon the Trim function. And where the heck did my line and position numbers/indicator go in the 2010 VBE????
    Last edited by brucemc777; 25 Sep 2010 at 13:08.
      My Computer


  2. Posts : 2
    Windows 7 32 bit
       #2

    Hi Bruce,

    and all others who have this problem, try this:

    In the VB Editor, go to Tools -> References. There remove the checkmarks of every reference that starts with "MISSING:".

    cheers,
    Stefan
      My Computer


  3. Posts : 53
    W7
    Thread Starter
       #3

    Interesting - been a while since I worked with it, but when I went over to check I didn't find any references that began with "missing". I will keep my eyes open next time I battle with it though! Thank-you.
      My Computer


  4. Posts : 2
    Windows 7 32 bit
       #4

    In my case it was the reference "Microsoft Calendar Control 11.0" that caused the trouble. After removing the checkmark, everything was fine.
    The other references I use in that file are:

    Visual Basic for Applications
    Microsoft Excel 14.0 Object Library
    OLE Automation
    Microsoft Office 14.0 Object Library
    Microsoft Forms 2.0 Object Library
      My Computer


  5. tc5
    Posts : 1
    win 7 64bit
       #5

    Thanks to all, that save me a lot of head scratching...
    One thing I bumped into was the "toolbox" still had the datepicker/calendar control added to it, just had delete it out of there and all worked fine.

    Again thanks
    will click at you later
    TC
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:33.
Find Us