Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-09-2015, 06:54 PM
Snaybot Snaybot is offline How to run code in Each table in the document instead of just the First one? Windows 7 64bit How to run code in Each table in the document instead of just the First one? Office 2013
Novice
How to run code in Each table in the document instead of just the First one?
 
Join Date: Sep 2015
Posts: 22
Snaybot is on a distinguished road
Default How to run code in Each table in the document instead of just the First one?

Code:
Sub Macro7()
'
' GBM2 Macro
'

Dim i As Long, StrTxt As String
' Setting the variable
With ActiveDocument.Tables(1)
' Active Documents in the table
  For i = .Rows.Count To 2 Step -1
' Counts the rows by 1 down
    If .Rows(i - 1).Cells.Count > 1 Then
' Rows will count by one cell
      If InStr(.Cell(i, 2).Range.Text, "Ensure S") = 1 Then
' if the second column starts with "Ensure S" you know what I mean the first part of the procedure in the step then
        StrTxt = Split(.Cell(i, 2).Range.Text, " ")(1)
' Until the End or until the space is found after "Ensure S"
        .Rows.Add BeforeRow:=.Rows(i)
' Add an extra row for the Grey Bar
        With .Rows(i)
          .Cells.Merge
          'Merge those Cells!
          .Shading.BackgroundPatternColor = -603930625
          'Grey those cells!
          .Range.Style = wdStyleNormal
          'wdStyleNormal is the normal font template, for me which is Times new roman 12 for others it could be arial or calabri based on the template
          .Range.ParagraphFormat.KeepWithNext = wdToggle
          'Keep with next
          .Range.Text = "Step " & StrTxt
          'add "Step" Text infront of the step number
          .Range.Rows.Height = 18
          'Height is configurable
          .Range.Bold = wdToggle
          'Bold the Grey Bar text
          .Range.Font.Size = 10
          'Now shrink the text
        End With
      End If
    Else
      i = i - 1
      ' Makes the program not crash <- Suprisingly the hardest part lol
    End If
  Next
End With
'
End Sub
I have this Code How do I run it for every table in the Document rather than only the first table?



Cross Posted at:
http://www.mrexcel.com/forum/excel-q...ml#post4337459
http://www.excelforum.com/excel-prog...first-one.html
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to run code in Each table in the document instead of just the First one? Code to add new row in table ksigcajun Word VBA 24 02-16-2023 03:09 PM
How to run code in Each table in the document instead of just the First one? VBA Code to take data from a table in word document and place it in a summary table VBLearner Word VBA 1 03-09-2014 08:42 PM
VBA sort table code mikec Excel Programming 8 10-01-2013 04:37 PM
How to run code in Each table in the document instead of just the First one? .OnAction only works in document with the code donbexcel Word VBA 1 11-02-2011 05:25 AM
how can I add a peace of code to MS document amlife Word VBA 0 03-03-2010 03:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft