Re: Help about Office word In C# - C# Discussion Boards

7-Aug-07 15:31

I want to control the Office Word's behavior using C#.
i.e. Create a new word document in local PC with specified path.
And if I open a remote word document I could control that when user close the document,Word should not quest a saving path but save the change into the remote region path(if the user selected save the change).

Becides these,I also want to know whcich behaviors that the Office Word have and I can retrieve these messages?

Thanks.

GOOD LUCK.

tker7-Aug-07 18:16

7-Aug-07 18:16

Hi,

Do you wish to open the Word doc from another process? Do you wish to populate it? Would you like to automate the creation of documents, either before Word opens or by helping the user after it has opened?

Basically to open Word with a new document you need to do the following:

First create a new Windows Forms project. Add a button to the default form.

Next add a reference to the Microsoft Office 12.0 Object Library & Microsoft Word 12.0 Object Library (for Office 2007) so you have access to the word objects. The Office 12.0 Object library is not strictly necessary, but you may find you need it to complete other operations further down the track.

Next use the following as the code behind for Form1:

//START CODE<br />
using System.Windows.Forms;<br />
using Word = Microsoft.Office.Interop.Word;<br />
<br />
namespace WordSample<br />
{<br />
    public partial class Form1 : Form<br />
    {<br />
        private object m_Missing = Type.Missing;<br />
<br />
        public Form1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {<br />
            //create word application<br />
            Word.Application word = new Word.Application();<br />
<br />
            //create word document<br />
            Word.Document wordDoc = new Word.Document();<br />
<br />
            //make visible<br />
            word.Visible = true;<br />
<br />
            //add document to application<br />
            wordDoc.Application.DocumentBeforeSave += new Microsoft.Office.Interop.Word.ApplicationEvents4_DocumentBeforeSaveEventHandler(Application_DocumentBeforeSave);<br />
            wordDoc = word.Documents.Add(ref m_Missing, ref m_Missing, ref m_Missing, ref m_Missing);<br />
<br />
        }<br />
<br />
        void Application_DocumentBeforeSave(Microsoft.Office.Interop.Word.Document Doc, ref bool SaveAsUI, ref bool Cancel)<br />
        {<br />
            //PUT YOUR PATH CODE HERE;<br />
        }<br />
<br />
    }<br />
}<br />
<br />
//END CODE<br />

That will create a new instance of word. To modify the closing behaviour there are a number of events available to you including the Application.DocumentBeforeSave or Application.DocumentBeforeClose events. I have included a dummy ApplicationBeforeSave event for you. There is extensive documentation on MSDN regarding the Word ObjectModel that lists all events (http://msdn2.microsoft.com/en-us/library/kw65a0we(vs.80).aspx[^]; http://msdn2.microsoft.com/en-us/library/aa192495(office.11).aspx[^] should get you started, there is also plenty about Office 12/2007 you'll find from there).

If you have any further questions please feel free to ask away. You also have a lot more options for automating word via VSTO with Document or Application level customisations that you may wish to consider.

Hope that helps, good luck and have fun Smile | :)

Toby Russell
Software Engineer

kcynic7-Aug-07 19:16

7-Aug-07 19:16

Thanks.
Although I am a beginer of C#,but I will glad to have a try.

Best wishes.

tker7-Aug-07 20:12

7-Aug-07 20:12

Hi kcynic,

The code I gave you will work straight out to open word from a windows form. Changing the path can easily be done in the event that is created for the document when you open it from the form, have a play with it and you should find it easy enough. If you have more questions please feel free to ask whatever. Mark was right; Office is incredibly easily and powerfully automated and can be customised to do many things for the user. If you are really serious about Office Automation look into VSTO. It gives a fantastic, totally managed code, interface for Office development.

Regards,

Toby

Toby Russell

kcynic7-Aug-07 21:33

7-Aug-07 21:33

All the words are good guide for me.But there also some problems puzzled me.
For example,I offen find some compling error like some .dll files are used somewhere so VS can not copy the created file to the local device.
Why?

tker8-Aug-07 16:31

8-Aug-07 16:31

There are a myriad of reasons why you might get some messages. My advice is to make sure you don't have any instances of your code running anywhere as that will cause errors such as the one you mentioned and to google the errors as they arise.

Toby

MarkB7777-Aug-07 18:53

MarkB777

7-Aug-07 18:53

I had a similar project, except it involved Excel. You'll be amazed how easy MS Office is to use in C#. Microsoft has good examples, try this one http://support.microsoft.com/kb/316384[^]

kcynic7-Aug-07 19:18

Getting reflection permissions with ReflectionPermissionAttribute

7-Aug-07 19:18

I will glad to read it carefully.
Thank you very much.

Luke Murray7-Aug-07 15:23

Luke Murray

7-Aug-07 15:23

Hey all. I am having a bit of trouble with ReflectionPermissions. I have some code that uses reflection to access properties of classes in a different assembly (also mine). The issue is it only gets the private fields from the top-most object, it does not see the private fields from any of the base objects.

I have been trying different things with ReflectionPermissionAttributes with no luck. I think I don't understand how to use it correctly.

Anyone got any ideas? Do I have to have the calling code set something or the objects with the private fields? Or the assembly in which they live?

On the calling class I have tried things like

[ReflectionPermission(SecurityAction.Assert, Flags = ReflectionPermissionFlag.AllFlags, MemberAccess = true, Unrestricted = true)]

with no luck.

Any help on this would be great. Thank you in advance.

Luke

Console component

noon427-Aug-07 14:31

noon42

7-Aug-07 14:31

Hello,

I'd like to make a (read only) console component.
Almost a multiline TextBox in read only with a fixed number of lines.

As a DOS console which use a fixed buffer, the old lines should be discarded.
To limit the line number, I tryed to limit the character number (which is ok in my case) like so :

int maxNumCharacter = 10000;

public void AppendText(String text)
{
textBox.AppendText(text);

if (textBox.Text.Length > MaxNumCharacter)
textBox.Text = textBox.Text.Remove(0, textBox.Text.Length - maxNumCharacter);
}

But setting the Text property is not that good because :
- It replaces all the textBox characters. It's slow.
- It also has the effect to move the scrollbar to the top and I need it allways at the bottom if the user doesn't move it.

Is there any way to do such a component ?

Thanks.

Luc Pattyn7-Aug-07 14:39

Luc Pattyn

7-Aug-07 14:39

Hi,

if your Control is to be line-oriented then I would go for a ListBox or a ListBox derivative.

The advantages are:
- its Items collection holds items of arbitrary type, could be simply strings.
- lines never get concatenated, they are kept in the Items collection; fast and easy
- you can limit the number of items you keep, i.e. you could append to the bottom,
and, if required, remove lines from the top
- it offers scroll bars, so you can easily do a scrolling DOS window, holding much more
lines than your screen could show at once.

The disadvantages are:
- selection, if required, is by lines, not an arbitrary from-to selection
- maybe some more, nothing comes to mind

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

noon427-Aug-07 14:51

noon42

7-Aug-07 14:51

Thanks for your answer.

I thought about using a listbox but the input text should not allways be formated line by line. As you pointed the selection cannot be arbitraty in this case.

Also, I think its quite heavy to use a listbox for this simple stuff (actually its nothing more than a fixed text buffer). I need it to be really fast and light.
I use it as an output log for a little game editor. This component can be filled 60 times per second if a log is made in the update loop.

Luc Pattyn7-Aug-07 15:04

Luc Pattyn

7-Aug-07 15:04

ListBox is ideal for logging; there is simply nothing else I would consider for logging.
I would never consider a TextBox for big, live pieces of text (anything larger than
3 lines of text, and/or adding/replacing 3 lines per second).
I have ListBoxes that consume 100 lines per second and more.

And I forgot at least one more advantage:
you can make the ListBox OwnerDraw, meaning you draw the lines yourself.
I do this for highlighting (painting some lines red or bold).
If handled correctly, there should be no speed penalty involved.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Interface VS Abstract classes

noon427-Aug-07 15:20

noon42

7-Aug-07 15:20

I agree. Listbox can be really good in many cases. But I guess it a question of taste.
For example in visual studio you can use both, the Output and/or the Tasklist.
I prefer to use the Output.

In my case the output text is formated by the user (a developper).
I cannot assume any formating, he is free. He should be able to write anything he wants and then select on one or multiple line (columns selection would be great too, as a CMD window)

As you said, with listbox you can use color, draw the lines yourself, etc..
It has a cost. Drawing a simple character buffer and updating only what needs to be updated is a lot faster than the insertion of listbox items, the selection of their colors (according a keyword in the line for example, etc...)

I may use a listbox component later for this purpose. Right now I need something different.

Thanks.

seemamltn7-Aug-07 13:58

seemamltn

7-Aug-07 13:58

I have an nterview where I was asked What is useful to use interface or abstract classes.

When We use interface and when we should use abstract classes?

Thanks in advance

seema

PIEBALDconsult7-Aug-07 14:07

PIEBALDconsult

7-Aug-07 14:07

And what did you say?

Christian Graus7-Aug-07 14:30

Christian Graus

7-Aug-07 14:30

An interface can be used in multiple, unrelated classes ( think IDisposable ). An abstract base class allows you to store a base type, for example, whenever I write paint tools, I use an abstract base type 'Tool' class, and store an instance of it in the control that uses it, it's always a type of tool, but the base class gives me a way to store any of them.

I've actually never had an interview for a company that didn't end up offering me a job. My first ever interview was the only one I failed, and I bought books and learned all I needed to go back a year later, and get a job from them. You need to move past the specific questions they asked and ask yourself what your inability to answer them tells you about broader areas in which you need to improve your knowledge.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Jeff.Hu7-Aug-07 17:16

Jeff.Hu

7-Aug-07 17:16

The usage of interface is like a contract. That is to use it to control the entry port and the output to fit some rule that you need.
And abstract class is like a context. It's containing the common attributes and deflaut behaviors those could be extented in the subclasses.

When we use it is meaning how do we use interface and abstract classes.
Use interfaces when something will change frequently. If you need to change your design, make it an interface. However, you may have abstract classes that provide some default behavior. Abstract classes are excellent for it. It let you define some behaviors, they force your subclasses to provide others

Jeff

tker7-Aug-07 18:32