Create new Word document with macro in C#

Question

5.00/5 (1 vote)

See more:

I have this situation:

I made an add-in for Word 2010 in visual studio 2010 (C#), which dynamicly adds new buttons to a new ribbon tab (data from sql database). Now when i click on a button, a new document with a macro needs to be opend. I have the needed macro in a document (.docm), and the path to it is in the database.

My problem now is, how do i create a new document with the macro from another document?

thanks.

Posted 4-Apr-11 23:42pm

mpower88

Add a Solution

Comments

Sergey Alexandrovich Kryukov 5-Apr-11 12:03pm

Word macro is itself quite a bad idea, and now you want to mix it with Office programming in .NET... Don't explain me why, I won't understand... :-)
--SA

Slacker007 5-Apr-11 12:23pm

Macros in Word have there place and they can be quite useful and efficient when used properly.

Sergey Alexandrovich Kryukov 5-Apr-11 13:07pm

Sorry, I disagree... overuse of Word... there are much better ways of working with document. If something is somewhat useful, it is not enough justification for using it.
--SA

Slacker007 5-Apr-11 13:20pm

I'm interested to hear what you have to say about other ways to work with Word. I'm also interested to hear how long you have developed applications that use and manipulate Microsoft Word.

Sergey Alexandrovich Kryukov 5-Apr-11 13:35pm

"I don't have to eat all egg to tell it's wrong". Not a good answer, I understand. None. Many times I managed to avoid something from the very beginning, something that others gave up much later and wasted time. Word in not structured well to be used for something except writing formatted texts.

Alternatives? Sure. Just one: XML documents with various representations via XSLT.

Sorry, I'm not in the mood for flames here. You do what you want, me too, OK?
--SA

Slacker007 5-Apr-11 13:42pm

Wasn't trying to start any "flames" and don't intend to. I have read a lot of your answers here in this forum and I find you to be extremely opinionated and one sided in your answers and dialogue with the OP's. This doesn't make your answers wrong but your approach is abrasive to say the least.

I just wanted to know why you were so adamant against using Word documents. Maybe you know something that I don't and I can learn from you.

Sergey Alexandrovich Kryukov 5-Apr-11 13:57pm

Too long discussion. Thanks for your notes though. I appreciate your criticism.
Perhaps we have rather different values?
--SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Slacker007 · Accepted Answer · 2011-04-05T00:02:00

Solution 1

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.

Posted 5-Apr-11 0:02am

Slacker007

Comments

mpower88 5-Apr-11 6:15am

Yes that is what i want, do you know how to do that? Do i need to save my document with macro as a .dotm? (word macro-enabled template)

Slacker007 5-Apr-11 6:35am

You need to create a base document with everything that you want in it including macros and save it as a template (I believe it is .dotm). Then call this document template from you C# code.

mpower88 5-Apr-11 6:44am

I've done that, now i have just 1 problem.
I call te template like this: "Globals.ThisAddIn.Application.Documents.Open(location);"
where location is the path to the template. but i realy open the template, but i need to open a new document based on the template... thx for your help btw!

mpower88 5-Apr-11 6:51am

I fixed it, this is my solution:
//create new document, location = path to template
Document doc = Globals.ThisAddIn.Application.Documents.Add(location);
//auto run macro
doc.RunAutoMacro(WdAutoMacros.wdAutoOpen);

Thank you for your help Slacker007 !

Slacker007 5-Apr-11 7:29am

You will open the template - this is supposed to happen. When the user clicks save in the template it will save it as a regular document and not a template. You are only opening an instance of the template not the template itself.

BTW - if you feel like it, then please vote on my solution appropriately. Thanks.

mpower88 5-Apr-11 7:37am

Well, i thought so too, but for some reason, it does not behave like that. It only does when i open the template manually... But my method works around that... thx for the input

Slacker007 5-Apr-11 7:42am

I am glad to see that you have come up with a final solution. Awesome!

CyberSecII 26-Oct-20 10:09am

hi slacker007 i have a similar question here https://www.codeproject.com/Questions/5282859/I-there-any-way-to-add-a-macro-programmatically-to can you help me with that?