• Excel Toolkit Functions

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Excel Toolkit Functions

    Author
    Topic
    WSandrewgibsonsw
    AskWoody Lounger
    March 30, 2001 at 11:17 am #354505

    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.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSAndrew Cronnolly
      AskWoody Lounger
      March 30, 2001 at 11:23 pm #521043

      If 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

      Reply | Quote
      • WSandrewgibsonsw
        AskWoody Lounger
        April 1, 2001 at 10:04 am #521108

        Although there is the VBA Toolkit Add-in, I need to know how to refer to the functions in my code. For example, Application.WorksheetFunction.NetWorkDays(…)?

        Reply | Quote
        • WSAndrew Cronnolly
          AskWoody Lounger
          April 1, 2001 at 5:24 pm #521130

          Try the Evaluate Method, e.g x = Evaluate(“NetworkDays(Now(),Now()+100)”), which can be shortened to x = [NetworkDays(Now(), Now()+100)].

          Hope that helps,

          Andrew

          Reply | Quote
          • WSandrewgibsonsw
            AskWoody Lounger
            April 2, 2001 at 8:33 am #521173

            Cheers, 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(..)’?!

            Reply | Quote
            • WSAndrew Cronnolly
              AskWoody Lounger
              April 2, 2001 at 2:46 pm #521226

              Actually these functions are part of Atpvbaen.xla. Howe.ver there can be problems depending on the the version of XL you have.

              Check article Q165134 at Microsoft’s knowledge base, and see if it can help you to resolve the problem.

              Andrew C

              Reply | Quote
            • WSandrewgibsonsw
              AskWoody Lounger
              April 3, 2001 at 11:09 am #521352

              Sorted! I hadn’t included a Reference to Aptbean.xla. By including this the Toolkit functions appear in the Object Browser. I don’t then need to qualify the reference to the use the function(s). For example, ‘MsgBox Networkdays(Now(),Now()+10)’ works beautifully!! Cheers.

              Reply | Quote
    Viewing 0 reply threads
    Reply To: Excel Toolkit Functions

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    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.