| Macros for Microsoft Excel Worksheet in Microsoft Word Document |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.word.vba.general · Group Profile
Author: AleksanderAleksander Date: Jul 18, 2008 00:25
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
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:=FalseEnd Sub
Sincerely,
Aleksander
|