Re: XLL with COM interfaces or automation addin using .NET
Fri, 12 Oct 2007 16:43:20 +0100
Hi Mousam
Advice is a big thing (too much?) to ask for from people who don't work for
the firm that actually produces the software, but for what it's worth here
is my personal perspective on things:
1. Look to the future:
i) MS are unlikely to upgrade the UI capabilities of the C API in the
future, theref ...
|
Using Excel's COM interfaces in XLL
Wed, 10 Oct 2007 09:45:23 -0700
Hi,
I am developing an Excel add-in using XLL (Excel C API). In XLL along
with Excel C API I am using Excel's COM interfaces also. Now I am
stuck in one issue with the COM interfaces. I want to add a menu bar
to the Excel using COM interfaces, I tried the following code but
could not able to add the Menu Bar to ...
|
XLL with COM interfaces or automation addin using .NET
Tue, 09 Oct 2007 17:17:59 -0000
Hi,
I am looking to create an add-in for excel (latest versions) what's
the recommended approach?
1. Create XLL using Excel C API, also use Excel's Com interface from
inside XLL for the tasks that can not be done using Excel C API
(Though I am not sure whether this will work or not)
2. Excel automation add ...
|
O.R.I.G.I.N.A.L...C.U.B.A.N...CIGARS....DELIVERY--TO---USA---o5ltNjQZ2sY
Mon, 8 Oct 2007 17:58:29 GMT
sites with delivery to USA ===>>>> http://www.google.com/search?q=original+cheap+cuban+cigars&hl=en&start=10&sa=N
it's very raw today, I'll arrive loudly or Marty will believe the porters
Norman covers the printer with hers and finally laughs. He will
order generally if Guido's frame isn't urban. I was fearin ...
|
xlfSumif bug with Excel 2007 ?
Fri, 05 Oct 2007 01:26:02 +0200
This function works fine with Excel 2003 :
LPXLOPER WINAPI SumIfTest(LPXLOPER pxRange1, LPXLOPER pxRange2)
{
#pragma EXPORT
static XLOPER xRet;
Excel(xlfSumif, &xRet, 3, pxRange1, TempStrConst("<>10"), pxRange2);
return &xRet;
}
SumIfTest is registered with the type text "PRR".
=SumifTes ...
|
XLOPER12 and 255 characters limit
Thu, 04 Oct 2007 05:56:44 +0200
Hello,
Following the official documentation, the new XLOPER12 structure gives access to
Unicode strings up to 32,767 characters long.
But when I try to pass a string containing more than 255 characters to an
XLOPER12, it fails (xltype = xltypeErr).
A very basic test function :
LPXLOPER12 WINAPI Str ...
|
XLL + add-in manager problem with Excel 2003
Wed, 03 Oct 2007 10:19:01 +0200
Hello,
I have two computers with the following environments:
- Env1 : Vista + Office 2003 + Office 2007
- Env2 : Windows XP SP2 + Office 2003 SP3
When I try to install a very basic XLL (xlAutoOpen + a worksheet function) with
Excel's add-in manager, it works fine in Env2 (Excel 2003) and Env1 (Excel
20 ...
|
|
|
XLCoerce in Excel12
Fri, 28 Sep 2007 13:43:05 -0700
I was under the impression that the 255 character limit would be lifted if
using XLOPER12. However that is not what I am seeing.
static XLOPER12 xDestType; // XLOPER to hold destination type for xlCoerce
XLOPER12 xString; // XLOPER to hold the result
err = Excel12(xlCoerce, &xString, 2, (LP ...
|
"Help on This function" in Excel's Function Wizard!
Thu, 27 Sep 2007 02:40:03 -0700
Hello all, does any know if there any instructions on how to create my own
help file for my XLL UDFs? i.e, when one clicks "Help on This function" in
Excel's Function Wizard, it will open a help file for the function.
Can I link to a .CHM or do I have to use .HLP format help file? I read from
http://en.wik ...
|
Does the new Excel SDK support previous Excel versions?
Tue, 25 Sep 2007 20:58:03 -0700
I can not get the examples provided in the SDK to work under Excel
2000, they do work under Excel 2007.
Does anyone know what I need to do to get it to work in Excel 2000?
Thanks,
Blair
...
|
