Avatar of mike suman
mike suman
Flag for United States of America asked on

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.
Microsoft Office

Avatar of undefined
Last Comment
Norie

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Norie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mike suman

ASKER
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.
Norie

Mike

Can you recall what i was that was marked as MISSING?
Your help has saved me hundreds of hours of internet surfing.
fblack61