Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Office 2010 - Left function

25 Sep 2010   #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????

My System SpecsSystem Spec

07 Oct 2011   #2

Windows 7 32 bit

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:".

My System SpecsSystem Spec
11 Oct 2011   #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 System SpecsSystem Spec

19 Oct 2011   #4

Windows 7 32 bit

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 System SpecsSystem Spec
13 Feb 2012   #5

win 7 64bit

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
My System SpecsSystem Spec

 Office 2010 - Left function

Thread Tools

Our Sites

Site Links

About Us

Find 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 11:18 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33