Morefunc dying
in [Programming]
|
Prev: Selecting & copying a named range through a listbox
Next: macro to sum with offset in 2 cell as other cell changed
From: Ron Rosenfeld on 12 Jan 2010 07:46 <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
From: Rick Rothstein on 12 Jan 2010 13:43 Are you using the latest version? Supposedly, Version 5 is compatible with XL2007. -- Rick (MVP - Excel) "Ron Rosenfeld" <ronrosenfeld(a)nospam.org> wrote in message news:5irok55enchld6opu5plpm3g3lf286s23b(a)4ax.com... > <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
From: Ron Rosenfeld on 12 Jan 2010 14:29 On Tue, 12 Jan 2010 13:43:42 -0500, "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> 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
From: Bernd P on 13 Jan 2010 05:02
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 |