Custom Formula does not load in Debug Mode through Code..

Aug 23, 2013 at 12:24 PM

I have used the "__Excel-Dna Step by Step C Add-In guide" to work through the sample exceldna project.

When I directly click on the '.xll' file present in the debug folder the excel opens and custom formula is present in the excel but the Custom Formula does not load when I run the project in Debug Mode through the .net Code.

I have followed the same stpes as given in document. Just that 'Start External Program' path is -'C:\Program Files\Microsoft Office\Office14\EXCEL.EXE' and 'Command Line Arguements' is - '[actual path where project debug folder is present]\FirstAddIn.xll'. I keep getting the errors like 'c:\documents.xlsx' does not exist once the excel opens. Also, I get #name when I type the custom formula when means that custom formula does not load.

Please Help.

Aug 24, 2013 at 7:52 AM
Hi All,

I figured out the issue.

Solution - 1). Put the command line arguments in double quotes.
Sometimes the path containing spaces is not recognized in windows.

2). Move the code to the root directory instead of the user space..

Hope this helps you.