Wei Lu
Yes I typed the name of the function in directly and I get a #NAME? error
The first article did not help because Excel does not fail. The second
article "Excel COM add-ins and Automation add-ins" was helpful but dated. I
used two books:
"Microsoft .NET Development for Microsoft Offrice" by Andrew Whitechaple
Microsoft press
"Visual Studio Tools for Office Usnig Visual basic 2005 with Excel, Word,
Outlook, and InfoPath" by Eric Carter and Eric Lippert, Addison Wesley
I would recommend both
Following the instructions explicitly in both, to build add-ins and as I
said they work just find on the development computer. However, when moved to
a computer with out the development environment they appear as an Automated
Add-in yet do not show in the insert function dialog box of Excel.
I am at a loss of where to look next.
--
Regards,
Mike Reed
"Wei Lu [MSFT]" wrote:
Hello Mike,
I would like to know whether you have loaded the Add-in and if you type the
function in your cell, did the function works?
Please let me know whether these KB article is helpful
Excel fails when Automation add-In loads
http://support.microsoft.com/kb/284876/
Excel COM add-ins and Automation add-ins
http://support.microsoft.com/kb/291392
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)