Can't access Interop properties from C#

Question

Can't access Interop properties from C#

Cédric SANCHEZ 1

Hello everybody,

I'm encountering a problem with a C# .NET 4.8 project, while trying to use Office interop. If I use Interop.Microsoft.Office.Interop.Excel, Interop.Microsoft.Office.Interop.Outlook or Interop.Microsoft.Office.Interop.Word, I can not access any properties. The only way to get any informations from the COM object is to use some methods.

Example :

Microsoft.Office.Interop.Word.Application _wordApplication;
var documents = _wordApplication.Documents;

This is not working anymore

Microsoft.Office.Interop.Word.Application _wordApplication;
var documents = _wordApplication.get_Documents();

This is working right now but encounters other problems.

Any advice to why those interops suddenly don't expose their properties ?

Thank you !

Viorel 88,321 Reputation points

2022-01-25T12:19:52.443+00:00

How to reproduce the problem?
Cédric SANCHEZ 1 Reputation point

2022-01-25T15:55:44.383+00:00

Only importing those COM and try to access some properties, only that sadly
Castorix31 68,491 Reputation points

2022-01-25T16:12:21.223+00:00

It works normally for me, but I have sometimes problems with Office Interop and they are usually fixed by a "Quick Repair" (in Control Panel, Right click on Office, Update; it mainly repairs registry)
Viorel 88,321 Reputation points

2022-01-25T17:57:56.787+00:00

How did you import those COM?

Jack J Jun 21,741 Microsoft Vendor

@Cédric SANCHEZ ，based on my test, I find that I can access the properties of Interop.

Please try the following code example to check if it works for you.

Microsoft.Office.Interop.Word.Application _wordApplication=new Microsoft.Office.Interop.Word.Application();  
 _wordApplication.Documents.Open(AppDomain.CurrentDomain.BaseDirectory + "1.docx", Visible: false);  
int count = _wordApplication.Documents.Count;  
 
Console.WriteLine(count );  
Console.ReadKey();

Jack J Jun 21,741 Reputation points Microsoft Vendor

2022-02-07T03:05:16.337+00:00

@Cédric SANCHEZ , is any update?

Viorel 88,321 Reputation points

2022-01-25T12:19:52.443+00:00

How to reproduce the problem?
Cédric SANCHEZ 1 Reputation point

2022-01-25T15:55:44.383+00:00

Only importing those COM and try to access some properties, only that sadly
Castorix31 68,491 Reputation points

2022-01-25T16:12:21.223+00:00

It works normally for me, but I have sometimes problems with Office Interop and they are usually fixed by a "Quick Repair" (in Control Panel, Right click on Office, Update; it mainly repairs registry)
Viorel 88,321 Reputation points

2022-01-25T17:57:56.787+00:00

How did you import those COM?
Jack J Jun 21,741 Reputation points Microsoft Vendor

2022-01-26T07:09:49.523+00:00

@Cédric SANCHEZ ，based on my test, I find that I can access the properties of Interop.

Please try the following code example to check if it works for you.

Microsoft.Office.Interop.Word.Application _wordApplication=new Microsoft.Office.Interop.Word.Application(); _wordApplication.Documents.Open(AppDomain.CurrentDomain.BaseDirectory + "1.docx", Visible: false); int count = _wordApplication.Documents.Count; Console.WriteLine(count ); Console.ReadKey();
Jack J Jun 21,741 Reputation points Microsoft Vendor

2022-02-07T03:05:16.337+00:00

@Cédric SANCHEZ , is any update?

Answer 1

Hi there!
I suggest you drop using Office interop in favor of OpenXML SDK
The latter needs a little bit of learning and supports only Office 2007+ documents, but there are lots of code samples over the Internet. Also, OpenXML SDK does not require Office installed on the machine, which excludes the influence of Office's own bugs on your program. I recommend investing some time in studying OpenXML SDK, this will surely pay off to you.

Can't access Interop properties from C#

1 answer

Activity