[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Office 2010 file formats

Posted on 2014-03-19
10
Medium Priority
?
263 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
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 …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

649 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