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

Similar help and support threads
Thread Forum
Find Office 2010 Updates, When Office 2010 Isn't Installed?
I don't know if maybe I'm the only one who runs into this problem or if it happens to a lot of people, but it seems to come up a lot for me. I have had this issue on many computers but right now I am setting up an old Dell Latitude E5510 for an employee and I have reformatted, installed all...
Microsoft Office
My Ctrl key function became a left mouse click
For some reason, every time I press the ctrl key, the function becomes the left mouse button click. For example, when I hover the mouse on a icon and press ctrl, it opens the application. In game, when I press ctrl I fire the gun. I tried: -tried different keyboard and mouse - both USB and ps/2...
Hardware & Devices
New Microsoft Office 2010 Activation- Outlook will not function
I hope you can help me with this one. I just purchased a new laptop that only a partial Office 2010 program pre-installed so I installed my authentic Office 2010 copy from my desktop to my laptop and had to call Microsoft to validate my product key. No problems there went smoothly. The problem is...
Browsers & Mail
File Validation from Office 2010 to Office 2003 and Office 2007
File Validation from Office 2010 to Office 2003 and Office 2007 - Softpedia
Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010
It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not take a few...
Microsoft Office

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 04:27.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App