Solved

Converting a MS Word excel embedded object back to a spreadsheet

Posted on 2011-09-02
8
257 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
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

832 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