NetworkDays not defined in VBA

Dear Experts,

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
WebJoeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Rory ArchibaldCommented:
The ATP functions are now built into Excel, so you can use Application.Networkdays or Application.WorksheetFunction.Networkdays without requiring any additional references.
WebJoeAuthor Commented:
Thank you, rorya, the prefix "Application." made the error mentioned above go away. But it still does not work, now I get an error 13 (type mismatch).
I cann the function with three arguments: The first two are dates and the third is an array of dates.

It looks like the new NetworkDays does not like the array of dates as set for additional holidays - but what format/data type does it accept?
Rory ArchibaldCommented:
It requires an array of serial numbers for the dates - so an array of Long or Double will work. (You can still pass dates to the array and they will be converted as required)

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
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 Excel

From novice to tech pro — start learning today.