<sigh. It seems morefunc.xll, Laurent Longre's excellent add-in, is less and
less functional in Excel 2007. I know have several functions that, when
implemented, result in Excel crashing. The most recent was INDIRECT.EXT, which
allows the use of the INDIRECT function on closed workbooks. If I had open the
workbook containing the function; and then opened the target workbook; Excel
would crash. Changing the INDIRECT.EXT to an INDIRECT function was the fix for
that behavior. Of course, now the target workbook has to be open.

There are some other functions that don't seem to work well in Excel 2007, as
well.
--ron

Are you using the latest version? Supposedly, Version 5 is compatible with
XL2007.

--
Rick (MVP - Excel)


"Ron Rosenfeld" wrote in message
...
<sigh. It seems morefunc.xll, Laurent Longre's excellent add-in, is less
and
less functional in Excel 2007. I know have several functions that, when
implemented, result in Excel crashing. The most recent was INDIRECT.EXT,
which
allows the use of the INDIRECT function on closed workbooks. If I had
open the
workbook containing the function; and then opened the target workbook;
Excel
would crash. Changing the INDIRECT.EXT to an INDIRECT function was the
fix for
that behavior. Of course, now the target workbook has to be open.

There are some other functions that don't seem to work well in Excel 2007,
as
well.
--ron

On Tue, 12 Jan 2010 13:43:42 -0500, "Rick Rothstein"
wrote:

Are you using the latest version? Supposedly, Version 5 is compatible with
XL2007.

Yes, I am. It is v 5.06. But there are a few ways in which it seems to crash
my Excel 2007 SP2, which was not a problem in previous versions.

--ron

Hello,

Is anybody in contact with him? Can we get the source code?

My addin is still in its start-up phase (let's say: toy status) but I
think its not too bad to develop with C++ Visual Studio Express 2008,
XLW and Boost:
http://sulprobil.com/html/excel_addin.html

Open source and an XLW-like license should not be an issue - at least
it would not be one for me.

Regards,
Bernd