XLL Plus - Frequently Asked Questions
Search
You can use the text box below to search the Frequently Asked Questions.
Topics
Frequently asked questions about XLL+ are listed below by topic.
- .NET
- 64-bit Excel
- Add-in Functions
- ADO
- AppWizard
- COM
- Compiler & Linker
- Deployment
- Excel Formula Wizard
- Exception handling
- Function Wizard
- Help
- Interaction between XLLs
- Licensing
- Macro Functions
- Menus & Toolbars
- Return Values of Add-in Functions
- Runtime
- Setup
- Uninstalling
- Upgrade
- User Interface
- Vectors
- Vectors & Matrices
- Visual Studio 2012
- Visual Studio 2015
- Visual Studio 2019
- Visual Studio 2022
.NET
| FAQ | Title | Date |
|---|---|---|
| Q0040 | HOW TO: How can I call methods in .NET assemblies? | 29-Dec-2006 |
64-bit Excel
| FAQ | Title | Date |
|---|---|---|
| Q0056 | INFO: How can I tell whether I am running an Excel 32-bit or 64-bit version? | 16-May-2014 |
| Q0058 | PRB: The XLL+ 64-bit build fails in Visual Studio 2015 with Error C1189 | 30-Jul-2016 |
| Q0064 | HOW TO: Upgrade a project to run in 64-bit Excel | 16-Apr-2019 |
Add-in Functions
| FAQ | Title | Date |
|---|---|---|
| Q0006 | HOW TO: How do I decide, at run time, which functions to register? | 3-Jul-2002 |
| Q0008 | PRB: The last arguments' descriptions are the same as the description of an earlier argument | 06-Jul-2002 |
| Q0020 | HOW TO: Is there a way to reproduce the way Excel returns errors? | 8-Nov-2005 |
| Q0022 | HOW TO: How do I use a vector<int> as an argument or a result? | 28-Mar-2006 |
| Q0023 | HOW TO: How do I truncate a numeric vector input at the first non-numeric cell? | 28-Mar-2006 |
| Q0024 | HOW TO: How do I filter a vector input to read only numeric cells? | 28-Mar-2006 |
| Q0029 | HOW TO: How can I open an XLL from another XLL? | 11-Jun-2006 |
| Q0030 | HOW TO: How do I call an add-in function in one XLL from another XLL? | 11-Jun-2006 |
| Q0032 | HOW TO: How can I open and close an XLL from Visual Basic for Applications? | 31-Aug-2006 |
| Q0033 | HOW TO: How can I force a cell to recalculate? | 18-Sep-2006 |
| Q0034 | HOW TO: How to constrain the sizes of vector or matrix inputs | 30-Sep-2006 |
| Q0035 | HOW TO: How can I make sure that a vector or matrix input is of a fixed size? | 30-Sep-2006 |
| Q0036 | HOW TO: How can I make sure that two vector inputs are the same size? | 30-Sep-2006 |
| Q0037 | HOW TO: How can I make sure that a matrix input is square? | 30-Sep-2006 |
| Q0038 | HOW TO: How can I make sure that two matrix inputs are the same size? | 30-Sep-2006 |
| Q0039 | HOW TO: How can I make sure that the size of a matrix input matches two vector inputs? | 30-Sep-2006 |
| Q0042 | HOWTO: Handle an input with mixed types | 24-Aug-2007 |
| Q0043 | HOWTO: How do I call COM objects from an XLL? | 30-Sep-2007 |
| Q0044 | HOWTO: How do I use Excel's COM interface from an XLL? | 14-Feb-2008 |
| Q0051 | HOW TO: How do I display a number in local format? | 22-Jun-2008 |
| Q0054 | HOW TO: How can I generate code to automatically handle a C++ exception? | 8-Jul-2012 |
| Q0055 | PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken | 30-Jan-2013 |
| Q0060 | HOWTO: Getting the row/column/workbook/worksheet from an XLL call | 7-Jun-2016 |
| Q0061 | PRB: 'Do not call in Formula Wizard' does not work in Excel 2013 and above | 31-Jul-2016 |
| Q0062 | HOW TO: Automatically make an array formula occupy the right number of cells | 24-Aug-2016 |
ADO
| FAQ | Title | Date |
|---|---|---|
| Q0043 | HOWTO: How do I call COM objects from an XLL? | 30-Sep-2007 |
AppWizard
| FAQ | Title | Date |
|---|---|---|
| Q0058 | PRB: The XLL+ 64-bit build fails in Visual Studio 2015 with Error C1189 | 30-Jul-2016 |
COM
| FAQ | Title | Date |
|---|---|---|
| Q0043 | HOWTO: How do I call COM objects from an XLL? | 30-Sep-2007 |
| Q0044 | HOWTO: How do I use Excel's COM interface from an XLL? | 14-Feb-2008 |
Compiler & Linker
| FAQ | Title | Date |
|---|---|---|
| Q0001 | PRB: When building a project, the compiler fails with error C1083 | 18-Jan-2002 |
| Q0004 | PRB: When building a project, the linker fails with error LNK2005 | 28-Nov-2005 |
| Q0013 | PRB: error C2309: 'sort' : is not a member of 'std' | 25-Jun-2004 |
| Q0018 | PRB: Linker error LNK2001 when calling 'C' functions from an XLL+ function | 25-May-2005 |
| Q0026 | HOW TO: How do I build an add-in with "Multi-threaded DLL" settings (/MD)? | 20-Apr-2006 |
| Q0055 | PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken | 30-Jan-2013 |
| Q0063 | HOW TO: Upgrade a project to Visual Studio 2015 | 6-Sep-2017 |
| Q0065 | HOW TO: Install the MFC individual component | 20-Jun-2020 |
Deployment
| FAQ | Title | Date |
|---|---|---|
| Q0011 | PRB: My XLL does not work on a user's machine | 28-May-2008 |
| Q0049 | HOWTO: Build an MFC add-in which needs no runtime DLLs | 28-May-2008 |
| Q0052 | PRB: Under Windows 7, REGSVR32 fails with error code 0x8007005 | 22-Aug-2011 |
Excel Formula Wizard
| FAQ | Title | Date |
|---|---|---|
| Q0002 | PRB: Functions with no arguments have no description in the Excel Formula Wizard | 01-Jun-2002 |
| Q0017 | HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard | 23-Nov-2005 |
| Q0032 | HOW TO: How can I open and close an XLL from Visual Basic for Applications? | 31-Aug-2006 |
| Q0061 | PRB: 'Do not call in Formula Wizard' does not work in Excel 2013 and above | 31-Jul-2016 |
Exception handling
| FAQ | Title | Date |
|---|---|---|
| Q0054 | HOW TO: How can I generate code to automatically handle a C++ exception? | 8-Jul-2012 |
Function Wizard
| FAQ | Title | Date |
|---|---|---|
| Q0002 | PRB: Functions with no arguments have no description in the Excel Formula Wizard | 01-Jun-2002 |
| Q0008 | PRB: The last arguments' descriptions are the same as the description of an earlier argument | 06-Jul-2002 |
| Q0010 | PRB: The XLL+ Function Wizard Toolbar has disappeared in Visual Studio 6 | 10-Sep-2002 |
| Q0014 | PRB: Error message: "Insufficient space in the undo buffer" | 11-Mar-2004 |
| Q0017 | HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard | 23-Nov-2005 |
| Q0019 | PRB: The XLL+ Function Wizard Toolbar menu items do not appear in Visual Studio .NET | 28-Nov-2005 |
| Q0022 | HOW TO: How do I use a vector<int> as an argument or a result? | 28-Mar-2006 |
| Q0023 | HOW TO: How do I truncate a numeric vector input at the first non-numeric cell? | 28-Mar-2006 |
| Q0034 | HOW TO: How to constrain the sizes of vector or matrix inputs | 30-Sep-2006 |
| Q0035 | HOW TO: How can I make sure that a vector or matrix input is of a fixed size? | 30-Sep-2006 |
| Q0036 | HOW TO: How can I make sure that two vector inputs are the same size? | 30-Sep-2006 |
| Q0037 | HOW TO: How can I make sure that a matrix input is square? | 30-Sep-2006 |
| Q0038 | HOW TO: How can I make sure that two matrix inputs are the same size? | 30-Sep-2006 |
| Q0039 | HOW TO: How can I make sure that the size of a matrix input matches two vector inputs? | 30-Sep-2006 |
| Q0041 | PRB: The XLL+ Function Wizard Toolbar menu items do not appear in Visual Studio 2005 | 27-Apr-2007 |
Help
| FAQ | Title | Date |
|---|---|---|
| Q0009 | HOW TO: How do I add help to my add-in? | 21-Dec-2005 |
| Q0063 | HOW TO: Upgrade a project to Visual Studio 2015 | 6-Sep-2017 |
| Q0064 | HOW TO: Upgrade a project to run in 64-bit Excel | 16-Apr-2019 |
| Q0066 | HOW TO: Install interactive XLL Plus help in Visual Studio 2019 | 27-Jun-2020 |
| Q0068 | HOW TO: Install interactive XLL Plus help in Visual Studio 2022 | 5-Mar-2023 |
Interaction between XLLs
| FAQ | Title | Date |
|---|---|---|
| Q0029 | HOW TO: How can I open an XLL from another XLL? | 11-Jun-2006 |
| Q0030 | HOW TO: How do I call an add-in function in one XLL from another XLL? | 11-Jun-2006 |
| Q0040 | HOW TO: How can I call methods in .NET assemblies? | 29-Dec-2006 |
Licensing
| FAQ | Title | Date |
|---|---|---|
| Q0012 | INFO: Do users of XLLs need licenses? | 31-Aug-2004 |
| Q0016 | INFO: What are the terms of the XLL Plus End User License Agreement? | 23-Nov-2005 |
Macro Functions
| FAQ | Title | Date |
|---|---|---|
| Q0021 | HOW TO: How do I set a cell's color? | 3-Feb-2006 |
| Q0028 | HOW TO: How do I get or set a comment on an Excel cell? | 18-May-2006 |
| Q0031 | HOW TO: How do I define a named range on an Excel worksheet? | 26-June-2006 |
| Q0033 | HOW TO: How can I force a cell to recalculate? | 18-Sep-2006 |
| Q0044 | HOWTO: How do I use Excel's COM interface from an XLL? | 14-Feb-2008 |
| Q0045 | HOWTO: How do I add commands to Excel's right-mouse menu? | 15-Feb-2008 |
| Q0046 | HOWTO: How to switch off alerts and warnings during a macro | 15-Feb-2008 |
| Q0047 | HOWTO: How to Freeze Panes | 15-Feb-2008 |
| Q0048 | HOWTO: How to prevent screen flicker during macros | 15-Feb-2008 |
| Q0050 | HOW TO: How do I find the last populated cell in a range? | 2-Jun-2008 |
| Q0051 | HOW TO: How do I display a number in local format? | 22-Jun-2008 |
| Q0053 | HOW TO: How to evaluate an Excel formula from a macro function | 3-Nov-2011 |
Menus & Toolbars
| FAQ | Title | Date |
|---|---|---|
| Q0007 | HOW TO: How do I add a new menu to Excel's menu bar? | 21-Dec-2005 |
| Q0027 | HOW TO: How do I save and restore the location of a toolbar? | 3-May-2006 |
| Q0045 | HOWTO: How do I add commands to Excel's right-mouse menu? | 15-Feb-2008 |
Return Values of Add-in Functions
| FAQ | Title | Date |
|---|---|---|
| Q0020 | HOW TO: Is there a way to reproduce the way Excel returns errors? | 8-Nov-2005 |
Runtime
| FAQ | Title | Date |
|---|---|---|
| Q0002 | PRB: Functions with no arguments have no description in the Excel Formula Wizard | 01-Jun-2002 |
| Q0006 | HOW TO: How do I decide, at run time, which functions to register? | 3-Jul-2002 |
| Q0011 | PRB: My XLL does not work on a user's machine | 28-May-2008 |
| Q0012 | INFO: Do users of XLLs need licenses? | 31-Aug-2004 |
| Q0040 | HOW TO: How can I call methods in .NET assemblies? | 29-Dec-2006 |
| Q0049 | HOWTO: Build an MFC add-in which needs no runtime DLLs | 28-May-2008 |
| Q0056 | INFO: How can I tell whether I am running an Excel 32-bit or 64-bit version? | 16-May-2014 |
| Q0060 | HOWTO: Getting the row/column/workbook/worksheet from an XLL call | 7-Jun-2016 |
| Q0061 | PRB: 'Do not call in Formula Wizard' does not work in Excel 2013 and above | 31-Jul-2016 |
Setup
| FAQ | Title | Date |
|---|---|---|
| Q0025 | HOW TO: How do I uninstall XLL+? | 13-Apr-2006 |
| Q0057 | PRB: Cannot install XLL+ with Visual Studio 2015. This product requires Microsoft Visual Studio 2015. | 27-May-2016 |
| Q0065 | HOW TO: Install the MFC individual component | 20-Jun-2020 |
| Q0069 | PRB: Installing XLL Plus silently | 7-Mar-2023 |
Uninstalling
| FAQ | Title | Date |
|---|---|---|
| Q0025 | HOW TO: How do I uninstall XLL+? | 13-Apr-2006 |
| Q0067 | PRB: Error in Visual Studio 2019 after uninstalling XLL Plus | 4-Jan-2021 |
Upgrade
| FAQ | Title | Date |
|---|---|---|
| Q0059 | PRB: My project fails to build in a new version of Visual Studio | 2-Jun-2016 |
User Interface
| FAQ | Title | Date |
|---|---|---|
| Q0007 | HOW TO: How do I add a new menu to Excel's menu bar? | 21-Dec-2005 |
| Q0009 | HOW TO: How do I add help to my add-in? | 21-Dec-2005 |
| Q0027 | HOW TO: How do I save and restore the location of a toolbar? | 3-May-2006 |
| Q0046 | HOWTO: How to switch off alerts and warnings during a macro | 15-Feb-2008 |
| Q0047 | HOWTO: How to Freeze Panes | 15-Feb-2008 |
| Q0048 | HOWTO: How to prevent screen flicker during macros | 15-Feb-2008 |
Vectors
| FAQ | Title | Date |
|---|---|---|
| Q0022 | HOW TO: How do I use a vector<int> as an argument or a result? | 28-Mar-2006 |
| Q0023 | HOW TO: How do I truncate a numeric vector input at the first non-numeric cell? | 28-Mar-2006 |
| Q0024 | HOW TO: How do I filter a vector input to read only numeric cells? | 28-Mar-2006 |
Vectors & Matrices
| FAQ | Title | Date |
|---|---|---|
| Q0034 | HOW TO: How to constrain the sizes of vector or matrix inputs | 30-Sep-2006 |
| Q0035 | HOW TO: How can I make sure that a vector or matrix input is of a fixed size? | 30-Sep-2006 |
| Q0036 | HOW TO: How can I make sure that two vector inputs are the same size? | 30-Sep-2006 |
| Q0037 | HOW TO: How can I make sure that a matrix input is square? | 30-Sep-2006 |
| Q0038 | HOW TO: How can I make sure that two matrix inputs are the same size? | 30-Sep-2006 |
| Q0039 | HOW TO: How can I make sure that the size of a matrix input matches two vector inputs? | 30-Sep-2006 |
| Q0062 | HOW TO: Automatically make an array formula occupy the right number of cells | 24-Aug-2016 |
Visual Studio 2012
| FAQ | Title | Date |
|---|---|---|
| Q0055 | PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken | 30-Jan-2013 |
Visual Studio 2015
| FAQ | Title | Date |
|---|---|---|
| Q0057 | PRB: Cannot install XLL+ with Visual Studio 2015. This product requires Microsoft Visual Studio 2015. | 27-May-2016 |
| Q0058 | PRB: The XLL+ 64-bit build fails in Visual Studio 2015 with Error C1189 | 30-Jul-2016 |
| Q0063 | HOW TO: Upgrade a project to Visual Studio 2015 | 6-Sep-2017 |
Visual Studio 2019
| FAQ | Title | Date |
|---|---|---|
| Q0065 | HOW TO: Install the MFC individual component | 20-Jun-2020 |
| Q0066 | HOW TO: Install interactive XLL Plus help in Visual Studio 2019 | 27-Jun-2020 |
| Q0067 | PRB: Error in Visual Studio 2019 after uninstalling XLL Plus | 4-Jan-2021 |
| Q0069 | PRB: Installing XLL Plus silently | 7-Mar-2023 |
Visual Studio 2022
| FAQ | Title | Date |
|---|---|---|
| Q0068 | HOW TO: Install interactive XLL Plus help in Visual Studio 2022 | 5-Mar-2023 |
| Q0069 | PRB: Installing XLL Plus silently | 7-Mar-2023 |