9

I need to automate office documents (Word & Excel) from my .Net4 app.

Since I can't really force my users to use a specific Office version I don't use interop assemblies or tlbimp, so my project doesn't contain any additional references nor will the whole app fail if Office is not installed (feature just won't be available).

Instead I ask the system which COM server can handle "Word.Application" or "Excel.Application":

dynamic app = Activator.CreateInstance(Type.GetTypeFromProgID("Word.Application"));
app.Foo();

I'm concerned how to properly dispose of the "app" object when I'm done with it, since now I have two internal management systems to worry about (COM reference counting and .Net reference tracking). Ideally I should be able to wrap the dynamic app object into a disposable wrapper class and to be sure that underlying COM object is unreferenced when the wrapper is disposed of.

EDIT: Also I'd like to know how to properly make the COM object "live on" when I'm done with it, since Word is in a separate process. I should be able to instantiate Word app, automate it and then free all my references but the Word app should stay open.

Boris B.
  • 4,933
  • 1
  • 28
  • 59
  • possible duplicate: http://stackoverflow.com/questions/2203968/how-to-access-microsoft-word-existing-instance-using-late-binding – Kris Ivanov Feb 28 '11 at 10:40
  • 2
    Not necessarily, the duplicate candidate is more about the instantiation side of COM from C#, this question is about disposal. – James Webster Feb 28 '11 at 10:43
  • 1
    Make sure you dispose of any intermediary COM objects too - http://stackoverflow.com/a/158752/188926 – Dunc Feb 26 '13 at 15:47

1 Answers1

8

I would definitely implement IDisposable and call Marshal.ReleaseComObject within it. Make sure you correctly implement the disposable pattern to avoid releasing the COM object more than once and reducing the reference count further than you should, although this may not matter if you are only going to create one instance of the COM object. I have implemented this pattern successfully in the past so you are definitely heading in the right direction.

I think Word will remain open even when the last COM object is reference counted to 0 in your app, unless you explicitly ask it to exit. ( Word.Application.Close() ?)

James Webster
  • 4,046
  • 29
  • 41
  • So in the example you linked I should replace Marshal.FreeHGlobal(nativeResource) with Marshal.ReleaseComObject(app)? That's it? – Boris B. Feb 28 '11 at 10:46
  • You don't need the if() block around it of course, and the managedResource stuff may be irrelevant to your use case, but yes that should otherwise properly clean up your COM reference. I'd recommend maybe not passing your IDisposable wrapper all around your code to minimise the rest of your system's exposure to this particular IDisposable. – James Webster Feb 28 '11 at 10:49