Macros for Microsoft Excel Worksheet in Microsoft Word Document

[Doug Robbins - Word MVP]

Already answered elsewhere. Please do not post the same question to multiple newsgroups.



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

Sincerely,
Aleksander

 

[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

Sincerely,
Aleksander