View Single Post
 
Old 08-03-2019, 10:20 AM
SamDsouza SamDsouza is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Aug 2019
Posts: 71
SamDsouza is on a distinguished road
Default

Thanks Andrew Lockton (Guessed) . You realy made me my first .Docm file with your coding. Indeed it strated off with VBA word
the begining was perfect

Thanks to you Gmayor
Yes i started from Excel.

It is just what i wanted but then i thought i could move on but got stuck when i wanted to insert again new line after the table
As this got me more intrested added and modified with your code in RED

Code:
Private Sub InsertingBlankLine()
Dim objWord As Object
Dim txtword As String, sh As Worksheet
Dim objDoc As Object
Dim objRange As Object
Dim objTable As Object
Dim intRows As Integer
Dim intCols As Integer

    txtword = "fsdhfkhfkdhfdskfhd fkdshfdkfhdskfhdsfd fdshgfdjdsjfg"
    On Error Resume Next
    Set objWord = GetObject(, "Word.Application")
    If Err Then
        Set objWord = CreateObject("Word.Application")
    End If
    On Error GoTo 0

    Set objDoc = objWord.Documents.Add
    objWord.Visible = True
    Set objRange = objDoc.Range
    With objRange
        .Text = txtword & vbCr 'add the paragraph break at the end of the text string
        .Collapse Direction:=0
    End With
    intRows = 8: intCols = 5
    Set objTable = objDoc.Tables.Add(objRange, intRows, intCols)
    '''''''objTable.Borders.Enable = True

    With objTable
    .Borders.Enable = True
    .Cell(1, 1).Range.Text = "row 1"
    .Cell(1, 1).Range.Bold = True
    .Cell(2, 1).Range.Text = "row 2"
    .Cell(3, 1).Range.Text = "row 3"
    .Cell(4, 1).Range.Text = "row 4"
    .Cell(5, 1).Range.Text = "row 5"
    .Cell(6, 1).Range.Text = "row 6"
    .Cell(7, 1).Range.Text = "row 7"
    .Cell(8, 1).Range.Text = "row 8"
    .Range.Font.Name = "Tahoma"
    .Range.Font.Size = 15
   End With
    
   Set objTable = Nothing

'''''Here also  i would like blank line and start
   txtword = "Paragraph / Line after table"

   With objRange
        .Text = txtword & vbCr 'add the paragraph break at the end of the text string
        .Collapse Direction:=0
    End With
'''''The above range started in the table of 1st Row

   Set objWord = Nothing
    Set objDoc = Nothing
    Set objRange = Nothing
''''''    Set objTable = Nothing
End Sub
Gmaxey tried yours but got me type mismatch error
at Set oRng = oTbl.Range

Glad to be here on this forum
Thank you guys
SamD
Reply With Quote