Unable to rebuild my project

Hi,

I've produced a C# automation addin for Excel and all works well. However, I'd like to be able to recompile the addin without closing Excel and reloading the addin. I've tried unchecking the addin from the addin list in the tools>addin menu, but it doesn't work. Does anyone know how to rebuild & overwrite the existing file without having to close Excel

Thanks !!


Answer this question

Unable to rebuild my project

  • Doug Woosley

    Thanks for the reply. Soooo frustrating/disappointing. Lets say I'm an addin developer and I typically recompile my an addin 10 times a day - if it takes 30 seconds to close and reopen Excel, over the course of a year I would spend over one working day closing and opening Excel... joy !! Scaling that over a big corporation means a fair chunk of wasted cash. The sad thing is that if I use XLL's (invented nearly 20 years ago), I don't have this problem. Is this progress

    I luv .NET - one of the best things MS has ever produced, but when its come to mixing .NET with Office I'm seriously disappointed. The concept is brilliant, but there's clearly no attention to detail.... type.Missing, type.Missing, type.Missing. Range.Value2 aaaghhhh!!! Whichever project manager is in charge of this shag show needs a good kicking and to be shown the door !!



  • nfreeze

    You can not do this if the file is in use by Excel you would have to close the process, removing/unloading the addin doesnt work unfortunately this is annoying but there is no way around this other than using the Edit and continue features which are a little hairy in this environment.

    Regards



  • SharonGuinee

    If I understand you right you want to keep your project running after a change

    What you can do is run in Debug mode, put a break in the code where you want to make changes, change your code and continue to run the project. It will recompile the changes and continue to work. It's the Edit and Continue feature, but I'm not sure if this is what you are asking.

    -= Maarten =-



  • Xne0

    Thanks for your reply. It's not quite what I'm looking for. Debugging is not the problem. I just want to be able to recompile my project (essentially overwriting my old dll) without having to restart Excel. For whatever reason, I'm unable to release my COM addin - possibly because its actually written in C# and has a COM callable wrapper....

  • Unable to rebuild my project