How to insert excel spreadsheet in Word document

[shubhi]

I am trying to embed excel spreadsheets in word document. When intried to select and copy paste from clipboard the excel is getting saved as image. Where as i want to save it as embedded object. Could somebody help.

 

[sivagelli]

A begin with... you can approach the problem statement by recording a Word Macro and customize it to BP -

Sub Macro1()
Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.12", FileName _
    :="C:\Test.xlsx", LinkToFile _
    :=False, DisplayAsIcon:=True, IconFileName:= _
    "C:\WINDOWS\Installer\{90140000-0011-0000-0000-0000000FF1CE}\xlicons.exe" _
    , IconIndex:=1, IconLabel:="Test.xlsx"
End Sub