Hi All

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) with two error messages appearing as follows:

"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"

The second of these indicates that the debugger chokes when it reaches the first of the UDF excel functions without the breakpoint activating or allowing me to step into the code of the function.

Is the only way to debug an xll/dll to create a separate basic application with the arithmetical function code stripped out of the xll function code and insetered in the basic application?

Ideally, I would want to be able to call the xll from Excel so that I know exactly what Excel is feeding to the xll function parameters. Any thoughts you may have would be appreciated.