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