Embedded Excel File Crashes Excel after Extraction from Word

sminabe

New Member
Joined
Dec 20, 2009
Messages
4
I have several .doc files with .xls files (both 97-2003 versions) embedded. When I open the .doc file in Word 2010 and try to open the .xls file I get the following error message: "Microsoft Word can't start the application required to open this object. An error occured and this feature is no longer functioning properly. Would you like to repair this feature now?"

When I try to repair the feature it fails and I still cannot open the .xls. If anyone has a fix for this then I'm set.

I also extracted the .xls files from the .doc file by
Saved the .doc as a .docx
Changed the .docx. file extension to .zip
Opened the .zip and extracted the .xls files in the word/embeddings folder

When I open the .xls in Excel 2010, the results are mixed and not consistent. Some files open and I can edit/save them. Most files don't open. Some files open only when a second file is opened. Some files that open are in Protected View mode and when I try to turn off Protected View it crashes Excel.

When I view the files in Windows Explorer, they don't have date created or date modified time stamps. It's only when I attempt to open the file that the date modified time stamp shows up. If the file doesn't open all the way and I close Excel, the date modified stamp goes away (not sure if this has any bearing on anything).

Looking for tricks/tips/help support.
Anything is appreciated.

Thanks all
 

sminabe

New Member
Joined
Dec 20, 2009
Messages
4
I was able to come up with this clumsy hack to my own post that worked for a couple documents. Would be interested if someone with more knowledge understands why this works and if there's a better solution. Seems it might be related to the OLE Object linking, but I have no clue and it's above my knowledge.


  • Open the .doc in Word 2010 and save as .docx.</SPAN>
  • Create a copy of the .docx file and rename the .docx extension to .zip.</SPAN>
  • Open the .zip file using WinZip (assume other compression tools will work as well)</SPAN>
  • Navigate to the word/embeddings file to view the embedded .xls files. (normally, you should be able to open the extracted files directly in Excel, but they don't open or crash Excel in this case)
  • Drag and Drop the .xls files from the zip interface to a desktop folder.</SPAN>
  • In the .docx file that was saved earlier delete the original .xls files, then use the Insert->Object->Create from File and Browse the where the new .xls files are located and select the first .xls file. Select the Display as Icon option and OK. Do this for each of the remaining .xls files.</SPAN>
  • The newly embedded .xls file should now be readable within Word.
  • </SPAN>
 

Forum statistics

Threads
1,081,747
Messages
5,361,038
Members
400,610
Latest member
ebey

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top