Link to home
Start Free TrialLog in
Avatar of abdb469
abdb469Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Converting a MS Word excel embedded object back to a spreadsheet

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.
Avatar of BusyMama
BusyMama
Flag of United States of America image

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.
Avatar of Flyster
Right-click the embedded spreadsheet and select Worksheet Object – Open. You can now copy that and paste it into a new worksheet.

Flyster
Avatar of abdb469

ASKER

No, that doesn't work. As already explained, I have tried that and it didnt work.
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.
Avatar of abdb469

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of abdb469

ASKER

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.

You're welcome. Glad I could help.