XLPack 6.0 User’s Guide

1. System requirements

  • Windows 10 (Version 2004 or later) or Windows 11
  • Excel in Office 365, 2021, 2019, 2016 or 2013 (except Store version Excel)

2. List of functions/subroutines

The following functions/subroutines are provided.

List of functions/subroutines

The orange parts are the basic functions. 27 worksheet functions and 138 VBA functions/subroutines are provided for free.

M1 to M4 are additional features. Including these features, total of 148 worksheet functions and 900 VBA functions/subroutines will be available. The addon licenses are required by in-app purchase to use these additional features.

3. Installing software (Basic functions)

Before beginning installation, please make sure the followings:

  • If the previous version of XLPack (Version 5.4 or earlier) is installed, uninstall it first.
  • If Excel is running, terminate it.

Download software from the following link and install it according to the attached document.

Download

Example of installation of basic functions
Run installer.

Start by clicking “Install”.

4. Installing software (Additional functions)

In addition to the XLPack (basic functions), install “XLPack Addons” App from Microsoft Store. It can be installed for free but it is not necessary if you are using only basic functions.

You can purchase additional functions (called as “addons” in Microsoft Store) by in-app purchase. Price for one year license is $14.99 for Modules 1 or 2, $11.99 for Modules 3 or 4, and $41.99 for a set of all Modules 1 to 4. You need your Microsoft account to proceed to purchase.

Clink following button to open Microsoft Store to install “XLPack Addons”.

Purchasing Addon example
Start XLPack Addon Manager.

Select “Purchase add-on license”.

Click “Purchase” button of necessary addon module.

On completion of purchase procedure in Microsoft Store, the status is changed to “License purchased (Exp. date …)”

Return to “Setup” menu, then it is noticed that “Some addon licenses are not activated”. Click “Setup” button.

Purchased addon modules are now active.

Close XLPack Addon Manager.

The purchased license is linked to your Microsoft account and can be used on up to 10 devices per one account.

If you update XLPack Addons after completion of the settings, you will need to start XLPack Addon Manager and setup again. Otherwise, “Addon not found” error will occur when XLPack is used. If store app auto update is enabled, this error may occur unawarely.

5. Setting up Excel

After installation of the software, you need to set up the Excel.

Enabling add-ins

  • Select Developer tab, and click Excel Add-Ins (Office 365 Excel, Excel 2019 or Excel 2016) or Add-Ins (Excel 2013).
  • In the “Add-ins available” list, check “XLPack Worksheet Functions”, and click “OK” so that the add-ins for worksheet functions is enabled.
  • In the “Add-ins available” list, check “XLPack Solver”, and click “OK” so that the add-ins for solver is enabled.

Once you enabled the add-ins, they will be always effective regardless of the Excel file.

Note – If you cannot find the Developer tab, select File tab -> Options -> Customize Ribbon and check Developer.

Add-in setting example

References setting for using VBA subroutines/functions

  • Open Excel file and run Visual Basic editor by clicking Visual Basic button in Developer tab.
  • Select Tools -> References, and click Browse and add C:\Users\User_Name\AppData\Roaming\Microsoft\AddIns\XLPack.xlam to the references.

References setting is effective only within the Excel file used here.

If “XLPack VBA Library” add-in is enabled according to the above mentioned procedure, “XLPack” appears in “Available Reference” list when “Tools” -> “References” is selected so that you can just check it to setup.

Note – To use VBA library, references setting is necessary for each Excel file. Since the references are saved in the Excel file, it is not necessary to set up again when you open the Excel file next time. However, if the Excel file is used on the other PC with different user name, you may need to set the references again.

Reference setting example

6. Uninstalling software

To uninstall the software, use “Windows Settings” -> “Apps”. You must uninstall both “XLPack 6.0” and “XLPack Addon Manager”. Choose “XLPack 6.0” or “XLPack Addon Manager” and click “Uninstall”. Then choose another one and click “Uninstall”.

7. Sample worksheet

Sample worksheets can be downloaded from the following site.

Sample worksheets

8. Known issue

Although you usually cannot call VBA functions as worksheet functions from a worksheet, you can call them in an Excel workbook that references XLPack.xlam and in all Excel workbooks if “XLPack VBA Library” is enabled as add-in. In those cases, the called VBA function returns a meaningless value or an error in most cases but in some cases Excel may abnormally terminate. Since the worksheet function distinguishes function names starting with W, please be careful not to call other functions from the worksheet.

Insert Function example
When you click fx (Insert Function) of formula bar, XLPack worksheet functions will be displayed under category “XLPack”.

On the other hand, normal VBA functions will be displayed under category “User Defined” and no help is available. Do not use these functions in worksheet.