On Apr 8, 11:03*am, nb0512 wrote:
I am running a 2003 macro in Excel 2007. It fails and says 'Can't find object
or library' and highlights the word Left in Left(somestring, somenumber).
In Help I see that Left does not exist in 2007, but it does in Access. So I
include a reference the Access library (Tools/References, etc.). This does
not help.

Any suggestions anyone ? Thanks ! *

Check your references to see if any of them are missing. My guess is
that because of the different versions, you're pointing to an old
library and the filename/path have changed. Uncheck the "MISSING"
reference and find the correct one in the list.

Chris M.