Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
I am working on an addin that define an UDF following an approach
similar to http://blogs.msdn.com/andreww/archiv...23/675939.aspx The UDF gets listed correctly under Excel 2003 (and recognized as well in the spreadsheet). Yet, under Excel 2007, I get #NAME! warning for the UDF, and the function does not appear to be listed in the function list. Does anyone know what could be the typical incompatibility issues between Excel 2003 and 2007 regarding registration of UDF? Thanks in advance, Joannès http://www.lokad.com sales forecasting |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
This site might help.
http://msdn2.microsoft.com/en-us/library/bb226683.aspx "Joannes Vermorel" wrote: I am working on an addin that define an UDF following an approach similar to http://blogs.msdn.com/andreww/archiv...23/675939.aspx The UDF gets listed correctly under Excel 2003 (and recognized as well in the spreadsheet). Yet, under Excel 2007, I get #NAME! warning for the UDF, and the function does not appear to be listed in the function list. Does anyone know what could be the typical incompatibility issues between Excel 2003 and 2007 regarding registration of UDF? Thanks in advance, Joannès http://www.lokad.com sales forecasting |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
Also, there is a new Com Shim Wizard v2.3, and Andrew posted a bug
report and patch for code generated by that release. See my blog for info. If anyone can tell me where my deployment is going wrong I'd be grateful. Joannes - does the lokad open source documentation provide deployment details? (Going to take a closer look at Lokad for other apps) Good luck with v2007 Tony Gravagno Nebula Research and Development remove.pleaseNebula-RnD.com/blog/tech/2007/11/excel-tools5.html JLGWhiz wrote: This site might help. http://msdn2.microsoft.com/en-us/library/bb226683.aspx "Joannes Vermorel" wrote: I am working on an addin that define an UDF following an approach similar to http://blogs.msdn.com/andreww/archiv...23/675939.aspx The UDF gets listed correctly under Excel 2003 (and recognized as well in the spreadsheet). Yet, under Excel 2007, I get #NAME! warning for the UDF, and the function does not appear to be listed in the function list. Does anyone know what could be the typical incompatibility issues between Excel 2003 and 2007 regarding registration of UDF? Thanks in advance, Joannès http://www.lokad.com sales forecasting |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
Tony, JLGWhiz, thanks for the links and the support. I will have a
look. does the lokad open source documentation provide deployment details? There is a MsBuild script named "excel-package.proj" in the / salesforecasting directory that compile the project and generate the MSI package (WiX is needed). Best regards, Joannès |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
Is this a dot-net thing? Are you using the correct PIA for 2007?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Joannes Vermorel" wrote in message ... Tony, JLGWhiz, thanks for the links and the support. I will have a look. does the lokad open source documentation provide deployment details? There is a MsBuild script named "excel-package.proj" in the / salesforecasting directory that compile the project and generate the MSI package (WiX is needed). Best regards, Joannès |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
On Dec 14, 9:03 pm, "Jon Peltier"
wrote: Is this a dot-net thing? Are you using the correct PIA for 2007? That's a .NET project with a C++ shim wrapper. Not use what "PIA" stand for (please apologize my ignorance). Best regards, Joannès |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF that works under Excel 2003 but not under Excel 2007
Not use what "PIA" stand for
PIA = Primary Interop Assembly. It is a redefinition of a COM object into a NET assembly. The Excel PIA redefines the existing COM Excel application in NET compatible terms. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Joannes Vermorel" wrote in message ... On Dec 14, 9:03 pm, "Jon Peltier" wrote: Is this a dot-net thing? Are you using the correct PIA for 2007? That's a .NET project with a C++ shim wrapper. Not use what "PIA" stand for (please apologize my ignorance). Best regards, Joannès |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF formula works in Excel 2003, does not work in Excel 2007 | Excel Discussion (Misc queries) | |||
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
Automation works with Excel 2003 but NOT Excel 2007 | Excel Programming | |||
chart works in excel 2007, not 2003 | Excel Programming |