Macros for Microsoft Excel Worksheet in Microsoft Word Document   

Hello,

Using macros in Microsoft Word, how is it possible to:

1) Set the number of rows and columns for Microsoft Excel WorkSheet?
2) Put the values into the cells of Microsoft Excel WorkSheet?

Recording macros in Microsoft Word gives the following code:


Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/17/2008 by
'
    Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.8", LinkToFile _
        :=False, DisplayAsIcon:=False
End Sub

Sincerely,
Aleksander

date: Fri, 18 Jul 2008 00:24:21 -0700   author:   Aleksander

Re: Macros for Microsoft Excel Worksheet in Microsoft Word Document   

Answered elsewhere.  Please do not post the same question separately to multiple newsgroups

-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

  "Aleksander"  wrote in message news:eVNaesE6IHA.4852@TK2MSFTNGP03.phx.gbl...
  Hello,

  Using macros in Microsoft Word, how is it possible to:

  1) Set the number of rows and columns for Microsoft Excel WorkSheet?
  2) Put the values into the cells of Microsoft Excel WorkSheet?

  Recording macros in Microsoft Word gives the following code:


  Sub Macro1()
  '
  ' Macro1 Macro
  ' Macro recorded 7/17/2008 by
  '
      Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.8", LinkToFile _
          :=False, DisplayAsIcon:=False
  End Sub

  Sincerely,
  Aleksander

date: Fri, 18 Jul 2008 09:47:08 +1000   author:   Doug Robbins - Word MVP