Sounds good, but I was expecting a different library to be missing.
If you can remember where the error was, what was the Left$() enclosing? I
think the Left$ was a bit of a red herring and what it was around was the
missing element.
Adding a reference to the Excel library should only add links to Excel
specific features. A reference to "Visual Basic for Applications" would
affect VBA type elements like Left$ (and a whole lot more).