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

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

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

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

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

Uninstalling

FAQ Title Date
Q0025 HOW TO: How do I uninstall XLL+? 13-Apr-2006

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