Macros for Microsoft Excel Worksheet in Microsoft Word Document
  Home FAQ Contact Sign in
microsoft.public.word.vba.general only
 
Advanced search
POPULAR GROUPS

more...

 Up
Macros for Microsoft Excel Worksheet in Microsoft Word Document         

Group: microsoft.public.word.vba.general · Group Profile
Author: Aleksander
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
no comments
diggit! del.icio.us! reddit!