VC++.Net - Debugging XLL
-
I have written an xll with basic arithmetical calculations. I want to use the debugger to step through those functions to confirm they are working properly. I have tried to do this by setting Excel as the Command application and a spreadsheet that loads the xll as the Command argument. I then place breakpoints throughout the functions. Unfortunately, the VC++.Net debugger never recognises the breakpoints (the warning glyph ? breakpoint appears). The two error messages are firstly: "Excel.exe does not contain debugging information. (No symbols loaded.) Click OK to debug anyway" Secondly: "The following breakpoint cannot be set: When 'double' changes Data breakpoints are not supported in the Common Language Runtime" Is the only way to debug an xll/dll to create a separate basic application to call the xll function? Ideally I would want to be able to call from Excel so that I know exactly what Excel is feeding to the xll function parameters. Any thoughts you may have would be appreciated. Regards Jeremy