Office 2010 - Left function

[brucemc777]

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????

 

[StefanH]

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

 

[brucemc777]

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.

 

[StefanH]

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

 

[tc5]

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