XLL+ Knowledge BaseSupport Home

FAQ Index

Topics

Frequently asked questions about XLL+ are listed below by topic.

.NET

FAQ Title Date
Q0040HOW TO: How can I call methods in .NET assemblies?29-Dec-2006

Back to top

ADO

FAQ Title Date
Q0043HOWTO: How do I call COM objects from an XLL?30-Sep-2007

Back to top

Add-in Functions

FAQ Title Date
Q0033HOW TO: How can I force a cell to recalculate?18-Sep-2006
Q0054HOW TO: How can I generate code to automatically handle a C++ exception?8-July-2012
Q0037HOW TO: How can I make sure that a matrix input is square?30-Sep-2006
Q0035HOW TO: How can I make sure that a vector or matrix input is of a fixed size?30-Sep-2006
Q0039HOW TO: How can I make sure that the size of a matrix input matches two vector inputs?30-Sep-2006
Q0038HOW TO: How can I make sure that two matrix inputs are the same size?30-Sep-2006
Q0036HOW TO: How can I make sure that two vector inputs are the same size?30-Sep-2006
Q0029HOW TO: How can I open an XLL from another XLL?11-June-2006
Q0032HOW TO: How can I open and close an XLL from Visual Basic for Applications?31-August-2006
Q0030HOW TO: How do I call an add-in function in one XLL from another XLL?11-June-2006
Q0006HOW TO: How do I decide, at run time, which functions to register?3-Jul-2002
Q0051HOW TO: How do I display a number in local format?22-June-2008
Q0024HOW TO: How do I filter a vector input to read only numeric cells?28-Mar-2006
Q0023HOW TO: How do I truncate a numeric vector input at the first non-numeric cell?28-Mar-2006
Q0022HOW TO: How do I use a vector<int> as an argument or a result?28-Mar-2006
Q0034HOW TO: How to constrain the sizes of vector or matrix inputs30-Sep-2006
Q0020HOW TO: Is there a way to reproduce the way Excel returns errors?8-Nov-2005
Q0042HOWTO: Handle an input with mixed types24-Aug-2007
Q0043HOWTO: How do I call COM objects from an XLL?30-Sep-2007
Q0044HOWTO: How do I use Excel's COM interface from an XLL?14-Feb-2008
Q0055PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken30-January-2013
Q0008PRB: The last arguments' descriptions are the same as the description of an earlier argument06-Jul-2002

Back to top

COM

FAQ Title Date
Q0043HOWTO: How do I call COM objects from an XLL?30-Sep-2007
Q0044HOWTO: How do I use Excel's COM interface from an XLL?14-Feb-2008

Back to top

Compiler & Linker

FAQ Title Date
Q0026HOW TO: How do I build an add-in with "Multi-threaded DLL" settings (/MD)?20-Apr-2006
Q0055PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken30-January-2013
Q0018PRB: Linker error LNK2001 when calling 'C' functions from an XLL+ function25-May-2005
Q0001PRB: When building a project, the compiler fails with error C108318-Jan-2002
Q0004PRB: When building a project, the linker fails with error LNK200528-Nov-2005
Q0013PRB: error C2309: 'sort' : is not a member of 'std'25-Jun-2004

Back to top

Deployment

FAQ Title Date
Q0049HOWTO: Build an MFC add-in which needs no runtime DLLs28-May-2008
Q0011PRB: My XLL does not work on a user's machine28-May-2008
Q0052PRB: Under Windows 7, REGSVR32 fails with error code 0x800700522-August-2011

Back to top

Excel Formula Wizard

FAQ Title Date
Q0032HOW TO: How can I open and close an XLL from Visual Basic for Applications?31-August-2006
Q0017HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard23-Nov-2005
Q0002PRB: Functions with no arguments have no description in the Excel Formula Wizard01-Jun-2002

Back to top

Exception handling

FAQ Title Date
Q0054HOW TO: How can I generate code to automatically handle a C++ exception?8-July-2012

Back to top

Function Wizard

FAQ Title Date
Q0037HOW TO: How can I make sure that a matrix input is square?30-Sep-2006
Q0035HOW TO: How can I make sure that a vector or matrix input is of a fixed size?30-Sep-2006
Q0039HOW TO: How can I make sure that the size of a matrix input matches two vector inputs?30-Sep-2006
Q0038HOW TO: How can I make sure that two matrix inputs are the same size?30-Sep-2006
Q0036HOW TO: How can I make sure that two vector inputs are the same size?30-Sep-2006
Q0023HOW TO: How do I truncate a numeric vector input at the first non-numeric cell?28-Mar-2006
Q0022HOW TO: How do I use a vector<int> as an argument or a result?28-Mar-2006
Q0034HOW TO: How to constrain the sizes of vector or matrix inputs30-Sep-2006
Q0017HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard23-Nov-2005
Q0014PRB: Error message: "Insufficient space in the undo buffer"11-Mar-2004
Q0002PRB: Functions with no arguments have no description in the Excel Formula Wizard01-Jun-2002
Q0010PRB: The XLL+ Function Wizard Toolbar has disappeared in Visual Studio 610-Sep-2002
Q0019PRB: The XLL+ Function Wizard Toolbar menu items do not appear in Visual Studio .NET28-Nov-2005
Q0041PRB: The XLL+ Function Wizard Toolbar menu items do not appear in Visual Studio 200527-Apr-2007
Q0008PRB: The last arguments' descriptions are the same as the description of an earlier argument06-Jul-2002

Back to top

Help

FAQ Title Date
Q0009HOW TO: How do I add help to my add-in?21-Dec-2005

Back to top

Interaction between XLLs

FAQ Title Date
Q0040HOW TO: How can I call methods in .NET assemblies?29-Dec-2006
Q0029HOW TO: How can I open an XLL from another XLL?11-June-2006
Q0030HOW TO: How do I call an add-in function in one XLL from another XLL?11-June-2006

Back to top

Licensing

FAQ Title Date
Q0012INFO: Do users of XLLs need licenses?31-Aug-2004
Q0016INFO: What are the terms of the XLL Plus End User License Agreement?23-Nov-2005

Back to top

Macro Functions

FAQ Title Date
Q0033HOW TO: How can I force a cell to recalculate?18-Sep-2006
Q0031HOW TO: How do I define a named range on an Excel worksheet?26-June-2006
Q0051HOW TO: How do I display a number in local format?22-June-2008
Q0050HOW TO: How do I find the last populated cell in a range?2-June-2008
Q0028HOW TO: How do I get or set a comment on an Excel cell?18-May-2006
Q0021HOW TO: How do I set a cell's color?3-Feb-2006
Q0053HOW TO: How to evaluate an Excel formula from a macro function3-November-2011
Q0045HOWTO: How do I add commands to Excel's right-mouse menu?15-Feb-2008
Q0044HOWTO: How do I use Excel's COM interface from an XLL?14-Feb-2008
Q0047HOWTO: How to Freeze Panes15-Feb-2008
Q0048HOWTO: How to prevent screen flicker during macros15-Feb-2008
Q0046HOWTO: How to switch off alerts and warnings during a macro15-Feb-2008

Back to top

Menus & Toolbars

FAQ Title Date
Q0007HOW TO: How do I add a new menu to Excel's menu bar?21-Dec-2005
Q0027HOW TO: How do I save and restore the location of a toolbar?3-May-2006
Q0045HOWTO: How do I add commands to Excel's right-mouse menu?15-Feb-2008

Back to top

Return Values of Add-in Functions

FAQ Title Date
Q0020HOW TO: Is there a way to reproduce the way Excel returns errors?8-Nov-2005

Back to top

Runtime

FAQ Title Date
Q0040HOW TO: How can I call methods in .NET assemblies?29-Dec-2006
Q0006HOW TO: How do I decide, at run time, which functions to register?3-Jul-2002
Q0049HOWTO: Build an MFC add-in which needs no runtime DLLs28-May-2008
Q0012INFO: Do users of XLLs need licenses?31-Aug-2004
Q0002PRB: Functions with no arguments have no description in the Excel Formula Wizard01-Jun-2002
Q0011PRB: My XLL does not work on a user's machine28-May-2008

Back to top

Setup

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

Back to top

Uninstalling

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

Back to top

User Interface

FAQ Title Date
Q0007HOW TO: How do I add a new menu to Excel's menu bar?21-Dec-2005
Q0009HOW TO: How do I add help to my add-in?21-Dec-2005
Q0027HOW TO: How do I save and restore the location of a toolbar?3-May-2006
Q0047HOWTO: How to Freeze Panes15-Feb-2008
Q0048HOWTO: How to prevent screen flicker during macros15-Feb-2008
Q0046HOWTO: How to switch off alerts and warnings during a macro15-Feb-2008

Back to top

Vectors

FAQ Title Date
Q0024HOW TO: How do I filter a vector input to read only numeric cells?28-Mar-2006
Q0023HOW TO: How do I truncate a numeric vector input at the first non-numeric cell?28-Mar-2006
Q0022HOW TO: How do I use a vector<int> as an argument or a result?28-Mar-2006

Back to top

Vectors & Matrices

FAQ Title Date
Q0037HOW TO: How can I make sure that a matrix input is square?30-Sep-2006
Q0035HOW TO: How can I make sure that a vector or matrix input is of a fixed size?30-Sep-2006
Q0039HOW TO: How can I make sure that the size of a matrix input matches two vector inputs?30-Sep-2006
Q0038HOW TO: How can I make sure that two matrix inputs are the same size?30-Sep-2006
Q0036HOW TO: How can I make sure that two vector inputs are the same size?30-Sep-2006
Q0034HOW TO: How to constrain the sizes of vector or matrix inputs30-Sep-2006

Back to top

Visual Studio 2012

FAQ Title Date
Q0055PRB: After installing Visual Studio 2012, XLL+ for earlier versions of Visual Studio is broken30-January-2013

Back to top

Copyright © Planatech Solutions Ltd 2002-2012. All trademarks are the properties of their respective owners.