VBA string functions not recognized in64-bit Excel

Yesterday I updated my MS Office suite to the 64-bit version. Today an application that uses Excel that I have been maintaining for nearly 30 years will not run. It throws "Library not found" errors for the string functions Left, Mid, Right and others. I interprest this to mean some library has not been loaded, but I can find no informatin on what specifically I should do to get back to where I was yesterday. Any help would be appreciated.
mike sumanRetiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Have you checked under Tools>References...?

If there is anything marked as MISSING note the name, uncheck it, close the workbook and re-open then try the code again.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mike sumanRetiredAuthor Commented:
To Norie: Yes, something WAS marked as missing (actually the second workbook opened, which seems odd) and on deleting that and restarting Excel the problem went away. I certainly thank you for that.

But I don't really understand what is going on. It took several tries to get both workbooks opened because opening the second usually closes the first, which is why I went over to the 64-bit Excel in the first place.  

To Rahul Yadav: Thanks. I guess I understand what you say. But it doesn't seem right that the problem just occurred one day after nearly 30 years when nothing I had done changed anything. I'm getting terribly tangled in what I think are MS problems, and I'm afraid I am over the hill.
0
NorieAnalyst Assistant Commented:
Mike

Can you recall what i was that was marked as MISSING?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.