Welcome to MSDN Blogs Sign in | Join | Help

Question For The UDF Authors Out There

Specifically, we’re interested in add-ins that create custom Function Groups (Function Groups show up in the Function Wizard, next to the built-in groups like All, Financial, Date & Time, Statistical, etc.), and add-ins that are delay-loaded.  For anyone that reads this in the next few days that creates add-ins, we would love to know:

  • Do your addin's create function groups?
  • Are your addin's delay-loaded? (we think this is pretty uncommon, but getting confirmation/contradiction of that would be great)
  • Do you have add-ins that both create function groups and are delay-loaded?

Thanks for your help.

Published Sunday, September 17, 2006 3:04 PM by David Gainer

Comments

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 5:47 AM by Jan
Slightly unrelated, but we have noticed that the "Insert Function" dialog is still very limited in Excel 2007. The category list is limited in length and the dialog is not resizeable. These two factors combined cause us (Global Investment Bank) untold misery. Our users typically have many Excel addins and eventually the addins drop of the end of the category list which means the only way to see the functions is to select the "All" category which then produces a very long and hard to navigate function list, especially as the dialog cannot be resized! Please make this better and Investment Bankers the world over will be very happy.

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 7:08 AM by Jan
Incidentally, if you havent seen this already check it out

http://www.managedxll.com/en

Incredibly easy way to make .NET XLL's with no COM stuff, we use extensively and it is excellent.

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 8:17 AM by David Parker
Do your addin's create function groups?
Yes, my VBA Add-In's create functions groups using Application.ExecuteExcel4Macro method.

Are your addin's delay-loaded?
No

Dave Parker

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 1:08 PM by Jason King
Our addin creates a function group but does not do delay loading.

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 3:42 PM by Nabil
Our Add-in creates funcions groupe, it's developed as an xll file, it works very well in excel 2000-Xp but not correctely in 2007 !!

It works in 2007 for small files !! can you explain that ?

Thanks in advance.

M. Cadoret
Bolka@bolka.fr

# re: Question For The UDF Authors Out There

Monday, September 18, 2006 4:02 PM by David Gainer
Thanks all for the feedback.  Jan, we did deal with some of the non-resizable dialogs this version (i.e. name management), but not all.  We will continue next time.

# re: Question For The UDF Authors Out There

Tuesday, September 19, 2006 5:09 AM by Jonesy
When you say next time, you mean next Office version?

If so this is a shame as this is probably the most used dialog in the application and seems to have had the least love since Office 2000!

Alternatively we are looking to write a replacement Insert Function dialog in .NET

# re: Question For The UDF Authors Out There

Tuesday, September 19, 2006 5:11 AM by Jonesy
...Could you at least allow the Category list to be longer than 29 items for this release? Why is it limited anyway?

# re: Question For The UDF Authors Out There

Tuesday, September 19, 2006 11:40 AM by Richard
Yes, our XLL now creates function groups correctly (unlike in B2). It isn't delay-loaded.

# re: Question For The UDF Authors Out There

Tuesday, September 19, 2006 12:25 PM by David Gainer
Jonesy, I mean I have added it to the list of improvements to look at when we start planning the next Office version, yes.  I am not sure why the category list is limited, but we would look at that as well.

# re: Question For The UDF Authors Out There

Tuesday, September 19, 2006 7:08 PM by Simon Murphy
Yep my xlls add categories
nope they are not delay loaded, and I dont think they ever would be.

cheers
Simon

# re: Question For The UDF Authors Out There

Thursday, September 21, 2006 6:09 AM by John Drummond
I hope I'm not the only one who doesn't understand the question!  My addin creates function categories and is loaded via Application.RegisterXLL in VBA as soon as the XLA (or xlm equivalent in XL12) loads.

# re: Question For The UDF Authors Out There

Thursday, September 21, 2006 3:37 PM by David Gainer
Nabil, I sent you email, but all XLL that worked in XL2003 should work in XL2007, so if you can send us information to help us diagnose the problem, we would apprecaiate it.
New Comments to this post are disabled
 
Page view tracker