We help IT Professionals succeed at work.

VBA string functions not recognized in64-bit Excel

mike suman
mike suman asked
on
109 Views
Last Modified: 2018-09-05
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.
Comment
Watch Question

Analyst Assistant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
mike sumanRetired

Author

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.
NorieAnalyst Assistant
CERTIFIED EXPERT

Commented:
Mike

Can you recall what i was that was marked as MISSING?

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.