The question I have is not new to EE, but the existing answers do not help. Here's my Problem:
I have an Excel solution from the days with Office 2003 that extensively uses functions (NetworkDays, Weekdays) from the "Analysis Toolpak - VBA". This all worked fine in the old environment. Now I need to get it to work with Office 2010. But, even after ensuring that the "nalysis Toolpak - VBA" is enabled in Excels Add-In manager and the reference to atbvbaen.xls is checked in the VBA reference dialogue, I still get the following error:
"Sub or Function not defined"
Any ideas are more than welcome