How do I hide word and excel from displaying on screen in C#

Question

0.00/5 (No votes)

See more:

Hi All,

I am trying to hide Word and Excel from displaying when I am processing some documents.
I know it is capable of not even being displayed on the taskbar but hidden as a process but I can't seem to get that to work.
I am also not sure if creating excel tables or charts is causing this problem as well.

Any advice is appreciated.
Thank you.

What I have tried:

Here is a code fragment that I currently have.

object missing = System.Reflection.Missing.Value;
            object readOnly = true;
            object addToRecentFiles = false;
            object visible = false;

            object filename = Path.Combine(Directory.GetCurrentDirectory(), "Lorem ipsum dolor sit amet.docx");

            Word.Application word = null;
            word = new Word.Application();
            word.Visible = false;

            Word.Documents documents = word.Documents;
            Word.Document doc = documents.Open(ref filename, ref missing, ref readOnly, ref addToRecentFiles, ref missing, ref missing, true, ref missing, ref missing, ref missing, ref missing, ref visible, ref missing, ref missing, ref missing, ref missing);
            doc.Activate();

Posted 22-Feb-18 14:40pm

amsga

Updated 22-Feb-18 21:19pm

Add a Solution

2 solutions

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)

Maciej Los · Answer 1 · 2018-02-22T21:20:00

Quote:
I know it is capable of not even being displayed on the taskbar but hidden as a process but I can't seem to get that to work.
I am also not sure if creating excel tables or charts is causing this problem as well.

Sorry, but you're wrong!
You did not specify what you mean by saying "can't seem to get that to work" and you didn't provide information about error message. Nevertheless...
The reason you can't get it to work is quite obvious... The problem is laying in here:

C#

doc.Activate();

You can't activate a document (move focus to it) when hosting application is invisible. Remove every line which uses methods: Activate() and Select() and everything should start working.

RDBurmon · Answer 2 · 2018-02-22T19:39:00

try this way , this works for me

C#

// Create an Application object

Microsoft.Office.Interop.Word.ApplicationClass ac = new Microsoft.Office.Interop.Word.ApplicationClass();

Microsoft.Office.Interop.Word.Application app = ac.Application;

app.DisplayAlerts = Microsoft.Office.Interop.Word.

WdAlertLevel.wdAlertsNone;

object filename = strFileName;

object missingValue = Type.Missing;

app.Visible = true;

Microsoft.Office.Interop.Word.

Document document = app.Documents.OpenOld(ref filename,ref missingValue, ref missingValue,ref missingValue, ref missingValue, ref missingValue,ref missingValue, ref missingValue, ref missingValue, ref missingValue);

app.Activate();

}

How do I hide word and excel from displaying on screen in C#

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0