Group:  Microsoft Excel ยป microsoft.public.excel.sdk
Thread: debugging .xll

debugging .xll
a7zulu[ at ]gmail.com 6/28/2007 6:55:42 PM
I am having some trouble creating an xll then debugging the xll when
it is used as an addin for excel.

when i go to debug and have excel.exe as the target process, i am
unable to create a breakpoint.

in the modules screen, its says my symbols are loaded

but the error is

"The module did not load at the default load address"

what is the problem and how can I resolve it?


Thanks,
Aaron

Re: debugging .xll
"Jesper Lund" <usenet[ at ]jesperlund.com> 6/28/2007 10:28:53 PM
a7zulu[ at ]gmail.com wrote:

[Quoted Text]
> I am having some trouble creating an xll then debugging the xll
> when it is used as an addin for excel.
>
> when i go to debug and have excel.exe as the target process, i am
> unable to create a breakpoint.

Is your XLL listed as argument to excel.exe in the debug setup?

--
Jesper Lund


Re: debugging .xll
a7zulu[ at ]gmail.com 6/29/2007 12:07:51 PM
i actually have the .xls spreadsheet set as the argument...some book
told me to do that. is that incorrect?


thanks


Re: debugging .xll
a7zulu[ at ]gmail.com 6/29/2007 12:11:29 PM
i tried using the .xls and the .xll as arguments, but I still get the
"The module did not load at the default load address" error


is the detailed instructions on how to get a xll debug online that i
could go looking for?

Re: debugging .xll
"Jesper Lund" <usenet[ at ]jesperlund.com> 6/29/2007 4:22:35 PM
a7zulu[ at ]gmail.com wrote:

[Quoted Text]
> i tried using the .xls and the .xll as arguments, but I still get
> the "The module did not load at the default load address" error
>
> is the detailed instructions on how to get a xll debug online
> that i could go looking for?

It works for me with .xll (the debug compile) as the only argument to
Excel. I have done it in VC++ 6.0 and VC++ 2005 Express, without any
problems. The only setup modification is that I have changed debug
information from "program database for edit and continue" to "program
database", see here
http://support.microsoft.com/kb/q194926/
but I am not sure that this would cause the specific problem you are
seeing.

--
Jesper Lund


Re: debugging .xll
"Jesper Lund" <usenet[ at ]jesperlund.com> 6/29/2007 4:38:22 PM
Jesper Lund wrote:

[Quoted Text]
> The only setup modification [...]

Actually, there is another thing. You need to set the macro security
setting in Excel to low; otherwise the XLL will not load, and you don't
get a warning about that.

--
Jesper Lund


Re: debugging .xll
a7zulu[ at ]gmail.com 6/29/2007 6:39:07 PM
yeah thats actually all set


so i loaded up an dll i used before the same error comes up saying my
symbols are loaded but module is not at the default address. but when
i set breakpoints everything still opened

should i be concerned about something else?


yeah thanks for your help so far

Home | Search | Terms | Imprint
Newsgroups Reader