C# - insert macro into word document using C#

Question

I am trying to insert a macro into eight Word documents using a C# program. I can open a word document and insert various things (particularly mailmerge, as that seem to be pretty prevalent on the net), but I cannot find any clues, that I understand, to point me in the right direction. I have the required macro in a .bas file and it just need slotting into my eight documents so that if I need to modify it I only have to do it once. Can anyone help please.

Michael Griffith · Answer

Dear Vulpes Thank you so much for your pointers. It looks very much just what I need. Unfortunatley I have to go out but will eagerly return to plough through those articles. I am very much a retired amateur so it may take me some time but it looks hopeful. I shall let you know how I get on. Once again thanks for your reply. kind regards Michael

Vulpes · Answer

This thread ( http://social.msdn.microsoft.com/forums/en-US/vsto/thread/2f71610b-712d-46be-836a-373d9f61405e ) which links to two Microsoft Support articles may help. The first article shows how to add a macro to an Excel WorkBook starting from its VBProject property so you should be able to adapt the code to add a macro to a Word Document which also has a VBProject property. This line adds the macro as a string: oModule.CodeModule.AddFromString(sCode); However I believe there's also an AddFromFile method so you could load your .bas file using that. The second Support article shows how to fix a security issue which may arise when doing stuff like this.

Michael Griffith · Answer

Thank you for your response. The eight documents are all prepared mailmerge documents on an Access database each with exactly the same AutoOpen macro which runs the merge linking to the appropriate table within the database. I feel there must be a way of updating the macro when I imorove it. E.g. at the moment one of the things it does is uodate a registry entry so that my c~ program knows when it has finished nd i now wish to improve that with a different macro sequence of commands. Kind regards Michael

Jiteendra Sampathirao · Answer

Hi I don't think you can import a macro from another document into a separate document on the fly. I could be off based here but don't you want to create a Word Template with the macro in this template and then when you create a new Word Doc (through your C# code) based on this new template. Source: code project Refer this link