How can I use Excel Toolkit Functions in VBA code. The Add-ins collection only allows you to load the Add-in, but the functions, such as NetWorkDays, don’t appear under WorkSheetFunction. Andy.
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Excel Toolkit Functions
Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Excel Toolkit Functions
- This topic has 6 replies, 2 voices, and was last updated 24 years, 2 months ago.
AuthorTopicWSandrewgibsonsw
AskWoody LoungerMarch 30, 2001 at 11:17 am #354505Viewing 0 reply threadsAuthorReplies-
WSAndrew Cronnolly
AskWoody LoungerMarch 30, 2001 at 11:23 pm #521043If you are referring to the Analysis ToolPak Add-In, there is a special VBA version (Analysis ToolPak – VBA) which you should install. If you go to Tools,Add-Ins, you should see it, just just make sure the box is checked. You will notice in the function wizard that 2 versions of the AddIn functions appear, one in caps the other (VBA) in proper case.
Hope that helps,
Andrew C
-
WSandrewgibsonsw
AskWoody Lounger -
WSAndrew Cronnolly
AskWoody Lounger -
WSandrewgibsonsw
AskWoody LoungerApril 2, 2001 at 8:33 am #521173Cheers, this works Ok. However, I feel sure I should be able to reference the function directly, without creating a string. The function must reside in the Funcres.xla Add-in, although I don’t know the name of the module. I’m look for something like ‘Workbooks(“funcres.xla”)…NetWorkDays(..)’?!
-
WSAndrew Cronnolly
AskWoody Lounger -
WSandrewgibsonsw
AskWoody LoungerApril 3, 2001 at 11:09 am #521352
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
5 hours, 56 minutes ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
8 hours, 38 minutes ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
3 hours, 12 minutes ago -
Windows Update orchestration platform to update all software
by
Alex5723
15 hours, 57 minutes ago -
May preview updates
by
Susan Bradley
3 hours, 20 minutes ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
5 hours, 31 minutes ago -
Just got this pop-up page while browsing
by
Alex5723
8 hours, 9 minutes ago -
KB5058379 / KB 5061768 Failures
by
crown
5 hours, 13 minutes ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
2 hours, 22 minutes ago -
At last – installation of 24H2
by
Botswana12
1 day, 7 hours ago -
MS-DEFCON 4: As good as it gets
by
Susan Bradley
2 hours, 34 minutes ago -
RyTuneX optimize Windows 10/11 tool
by
Alex5723
1 day, 19 hours ago -
Can I just update from Win11 22H2 to 23H2?
by
Dave Easley
1 day, 13 hours ago -
Limited account permission error related to Windows Update
by
gtd12345
2 days, 9 hours ago -
Another test post
by
gtd12345
2 days, 9 hours ago -
Connect to someone else computer
by
wadeer
2 days, 3 hours ago -
Limit on User names?
by
CWBillow
2 days, 6 hours ago -
Choose the right apps for traveling
by
Peter Deegan
1 day, 20 hours ago -
BitLocker rears its head
by
Susan Bradley
1 day, 4 hours ago -
Who are you? (2025 edition)
by
Will Fastie
1 day, 3 hours ago -
AskWoody at the computer museum, round two
by
Will Fastie
1 day, 23 hours ago -
A smarter, simpler Firefox address bar
by
Alex5723
2 days, 19 hours ago -
Woody
by
Scott
3 days, 4 hours ago -
24H2 has suppressed my favoured spider
by
Davidhs
1 day, 4 hours ago -
GeForce RTX 5060 in certain motherboards could experience blank screens
by
Alex5723
3 days, 19 hours ago -
MS Office 365 Home on MAC
by
MickIver
3 days, 13 hours ago -
Google’s Veo3 video generator. Before you ask: yes, everything is AI here
by
Alex5723
4 days, 9 hours ago -
Flash Drive Eject Error for Still In Use
by
J9438
1 day, 4 hours ago -
Windows 11 Insider Preview build 27863 released to Canary
by
joep517
5 days, 4 hours ago -
Windows 11 Insider Preview build 26120.4161 (24H2) released to BETA
by
joep517
5 days, 4 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.