Jump to content
Business Intelligence & Analytics for Digital Transformation

About This Club

Join the club and share tips and tricks of VBA macros for Excel

More Info

vba - excel programming

  1. What's new in this club
  2. Sub word_excel_multitable() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.WorkSheet Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) rn = 0 cn = 0 For Each t In ActiveDocument.Tables For Each r In t.Rows For Each c In r.Cells xlSheet.Range("A1").Offset(rn, cn).Value = Left(c, Len(c) - 1) cn = cn + 1 Next c cn = 0 rn = rn + 1 Next r rn = rn + 2 Next t End Sub The code has to be pasted in module of word document Set reference for Excel object library in word so that word can write in Excel Click Tool > References
  3. Done filling names in highlighted cell. It was interesting.
  4. Excited to learn more and implement in my work. You are teaching it very well.
  5. Learn how to count, sum and display running totals
  6. Version 1.0.0

    6 downloads

    Two macro files
  7. VBA Tutorial 14 : For loop examples to read data write data & transform data
  8. Version 1.0.0

    1 download

    Two files Transform data has two sheets in which one is assignment
  9. Version 1.0.0

    4 downloads

    For loop examples Profit loss example
  10. Version 1.0.0

    17 downloads

    VBA Tutorial 12 : Logical Test If Else Statement Macro file
  11. Version 1.0.0

    3 downloads

    Download code for reference
  12.  

Announcements




×
×
  • Create New...