JPDO
10-23-2004, 06:49 AM
Hello,
Could any one tell me how i can "paste" an xls-sheet into a Word document?
The result should have an Excel-like presentation.(table with rows & columns)
Not a non-formatted text.
I try to include the Excel-sheet like an object but i do not want that there is a constant link between the Word document and the xls-workbook.
These are my statements:
Application.Workbooks.Open "C:\atest\pusectpf.xls"
Application.Worksheets("Crit").Activate
Application.ActiveSheet.UsedRange.Select
Application.Selection.Copy
ActiveDocument.Paragraphs(ActiveDocument.Paragraphs.Count).Range.PasteSpeci al
_ DataType:=wdPasteOLEObject
Application.CutCopyMode = False
Application.Windows("Pusectpf.xls").Close SaveChanges:=False
Is this the right way Or not ? :dunno
Thanks in advance for any reply.
Could any one tell me how i can "paste" an xls-sheet into a Word document?
The result should have an Excel-like presentation.(table with rows & columns)
Not a non-formatted text.
I try to include the Excel-sheet like an object but i do not want that there is a constant link between the Word document and the xls-workbook.
These are my statements:
Application.Workbooks.Open "C:\atest\pusectpf.xls"
Application.Worksheets("Crit").Activate
Application.ActiveSheet.UsedRange.Select
Application.Selection.Copy
ActiveDocument.Paragraphs(ActiveDocument.Paragraphs.Count).Range.PasteSpeci al
_ DataType:=wdPasteOLEObject
Application.CutCopyMode = False
Application.Windows("Pusectpf.xls").Close SaveChanges:=False
Is this the right way Or not ? :dunno
Thanks in advance for any reply.