Solved

Converting a MS Word excel embedded object back to a spreadsheet

Posted on 2011-09-02
8
263 Views
Last Modified: 2012-05-12
I received a MS Word document with a MS Excel embedded object.

If I double click on the object, I can open the object spreadsheet within word and play with the cells.  Is there anyway I can reverse the process so that the object opens as a fully excel spreadsheet in Excel as I want to get access to the spreadsheet and save it as an *.xls file?

I tried coping and pasting after double clicking the object, but its no good.

Thanks.
0
Comment
Question by:abdb469
  • 4
  • 3
8 Comments
 
LVL 7

Expert Comment

by:BusyMama
ID: 36474978
I found some code here:  http://vbadud.blogspot.com/

(scroll down to the August 25, 2010 entry, about the middle of the page)

But haven't been able to try it myself yet.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 36475479
Right-click the embedded spreadsheet and select Worksheet Object – Open. You can now copy that and paste it into a new worksheet.

Flyster
0
 

Author Comment

by:abdb469
ID: 36476500
No, that doesn't work. As already explained, I have tried that and it didnt work.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 22

Expert Comment

by:Flyster
ID: 36476547
Is your document protected? I was able to take an embedded spreadsheet in Word and copy it to Excel. What versions are you running? Would it be possible for you to post a sample document? Nothing with sensitive information as all posts are opened to the public.
0
 

Author Comment

by:abdb469
ID: 36479241
The word document is likely to be MS Word 2003 and the embedded spreadsheet will be excel 2003.  Unfortunately I cannot post a sample as it contains data in there which is too much to remove.  

The document is not protected.

Thx.
0
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 36479534
OK, I just tried this with 2003 and it works the same as in 2010. Right-Click the embedded spreadsheet in Word and select WORKSHEET OBJECT - OPEN. That opens it in a workable spreadsheet. You can copy that and then paste it in a new or existing workbook. If you try to just copy it and paste it into Excel, all you're doing is pasting an image.
0
 

Author Comment

by:abdb469
ID: 36480213
Thanks, it works now from home.  Not sure why I couldnt get this to work in the office, but this will suffice as I have access to the spreadsheet like you explained.

0
 
LVL 22

Expert Comment

by:Flyster
ID: 36480831
You're welcome. Glad I could help.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
combine fist two words in a cell 2 25
MS Excel Formula Help 3 35
remove extra space at end of cell 12 35
how to ignore blank cells from the data validation list? 16 33
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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 …

821 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