Un-embedding an Excel object

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Help!

I have a Word document with an embedded Excel
spreadsheet. I want to save/convert only the embedded
object back to its original format as an Excel document.

How do I "Un-Embed"?
 
I'm not sure if this is the best way (I'm pretty sure it can't be!)

But I had to do something like with with a workbook embedded into powerpoint
(and I can just barely spell powerpoint!).

(I just tried it in MSWord and it worked there, too.)

I double clicked on the embedded workbook so that I could see the worksheet
tabs. From there I right clicked on the worksheet tab and chose "view code".

(I could also have hit alt-F11 to get to _excel's_ VBE--be careful, you want to
be in excel--not Word.)

Then I hit ctrl-G to see the immediate window.

Then I typed this command and hit enter:

activeworkbook.saveas "C:\text.xls"

(close the windows and close up word and see if you can open your workbook in
excel)

======
But I'm waiting for a better answer--this can't be the right way.
 
Back
Top