Macros for Microsoft Excel Worksheet in Microsoft Word Document

  • Thread starter Doug Robbins - Word MVP
  • Start date
D

Doug Robbins - Word MVP

See the article "Control Excel from Word” at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm

--
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

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
 
A

Aleksander

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
 
Top