?
Solved

Office 2010 file formats

Posted on 2014-03-19
10
Medium Priority
?
262 Views
Last Modified: 2014-04-28
A 3rd party .NET application is attempting to open an Excel/Word file format from Office 2010, for this example let's stick with MS Word, but the document gives an error message that the vendor says comes from Microsoft.  An Internet search on the error number (-2147221504) has produced may different suggestions and I feel like I have attempted many of them with no luck.

One catch, there are some PC's that this procedure works in our environment but most produce the result above.  We have made a comparison of applications but there does not seem to be an obvious difference.

On ALL PC's (good and bad) we have verified that the same Office 2010 files are installed with the same svc packs and updates.  We have a mix of WinXP and Win 7 PC's with some of each working/failing.

What have we tried:
We have disabled ALL add-ins (Excel/Word)
We have verified the .NET versions are the same
We have verfied the Microsoft.Office.Interop.xxx files are of the same versions (I am waiting to hear from the Vendor to find out which Interop file they are using).  They have not told me yet.
We have attempted the basics in the registry but we are not totally convinced there is not an old registry setting from the Office 2003 installation that may be causing issues.  Maybe something that is telling 2010 to open an older file format when it is not.

What system files does Word/Excel use to open a document?

The 3rd party vendor is blaming the environment but they are not being helpful with the process they are using to open office documents so I am working blind.  As a developer at my company I am charged with troubleshooting this issue so much of my thought process involves things from the software development process.  I know how I would develop this but as you know that does not mean they would do the same.

I know this is a shot in the dark and you all have less information at your disposal but......Any ideas?

Thank you,

David
0
Comment
Question by:dbote
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 15

Expert Comment

by:DrTribos
ID: 39940944
One of the first things I do is create a brand new user profile and try with that.  Either way I'd be keen to know how this resolves.
0
 
LVL 1

Author Comment

by:dbote
ID: 39942861
Dr,

Thanks for the suggestion.  I had tried that but it did not work.

It seems like Word is opening in the background but there is an error message that goes unattended because users cannot see it and then times out.  The reason I say this is that you see the WINWORD process started but you cannot switch to it to address any issues.  Also, when you close the parent application Word flashes in the background.

Somehow it seems like OLE Automation starts Word will not open the file.  However, the files open manually with a regular session of Word/Excel.

Thanks for your assistance,

D
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 39943961
Does it make a difference if Word is already running when the 3rd party app tries to open it?

I am working with a Word app that, on opening, opens XL in the background to get some settings form a spreadsheet.  Occasionally when the universe is working against me Word crashes without any error information displayed on screen.

The last time I found that Excel was open and simply closing it fixed the issue (the code should have been able to deal with that, but that's another story).  

I note you are a developer at your company, if your company is anything like the one I was working for then you might not have used Visual Studio (pls forgive me for suggesting this if you have), you can download a free trial.  I found I could get get a whole lot of error information about what happened as word was trying to open.  I'm VERY new to VS so not really able offer more than that, just an avenue to explore.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

by:dbote
ID: 39945326
No.  The same result happens.

I am very familiar with VS.  What were you thinking I should try?

I am able to extract a bit of information from the 3rd party software and the error code states "There is no registered application for .docx files".  Although the association is definitely set correctly as a double click in the OS environment will open the file in  the proper application.  

Thank you,

D
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 39946609
What were you thinking I should try?

Sorry I'm not sure what to try there.  I stumbled across something about 2 weeks ago.  My code worked in Word 2007 (XP), 2010 (Win 7, Win 8) but not 2013 (Win 8).  Then one day after a MS update it stops working in Wrd 2010 - I could not open any file going back nearly a month of backups...

I'd been using VS for about 3 days (yep, pretty green) and found something that allowed me to view errors for word trying to open... for the life of me I can't seem to find it back.

I am using the super premium trial of a $20K package... Ultimate 2013, are you on the same?
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 39947283
0
 
LVL 1

Author Comment

by:dbote
ID: 39965977
Since the error only happens within the 3rd party vendors application and I have provided thorough information to them the 3rd party vendor has agreed to get their software development people involved.  I'm not expecting a quick resolution to this issue but they could surprise me.

Once I get an answer from them I will definitely post the resolution.
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 39970884
Cheers, looking forward to the update :-)
0
 
LVL 1

Accepted Solution

by:
dbote earned 0 total points
ID: 40018350
I am still working with the vendor for a definitive solution.  Not sure I will even be able to post it here but I do not want to classify this as abandoned as I think Experts Exchange is a valuable resource for future issues.

DB
0
 
LVL 1

Author Closing Comment

by:dbote
ID: 40026803
I'm not going to get the answer here so I want to close out this question.

DB
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question