Getting Data From Excel Sheet Embedded in Word

[johnnymagee]

I want to be able to either:
(1) use an excel table embedded in a word doc like any other Excel book, or
(2) copy and paste the Excel object into Excel

I've no idea about doing (1) and am stuck on (2)

Set owd = New Word.Application

Set owdSource = owd.Documents.Open("blahblahblah.doc")

'ADD NEW SPREADSHEET
Set owbkTemp = oXL.Workbooks.Add
Set rPaste = owbkTemp.Sheets("Sheet1").Range("A1")
owdSource.Shapes(1).Select
Selection.Copy

rPaste.PasteSpecial xlPasteValues

 

[SkipVought]

Hi,

Sounds to me like this is VBA. Please post in the VBA Forum forum707.


Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}