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 cells_example() Range("J10").Cells(1, 1).Value = "Usman" Range("J10").Cells(1, 4).Value = "Usman" Range("J10").Cells(5, 3).Value = "Usman" Range("J10").Cells(8, 1).Value = "Usman" Range("J10").Cells(3, -2).Value = "Usman" Range("J10").Cells(1, -4).Value = "Usman" Range("J10").Cells(-3, -3).Value = "Usman" Range("J10").Cells(-5, 1).Value = "Usman" Range("J10").Cells(-2, 3).Value = "Usman" End Sub
  3. 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
  4. Done filling names in highlighted cell. It was interesting.
  5. Excited to learn more and implement in my work. You are teaching it very well.
  6. Learn how to count, sum and display running totals
  7. Version 1.0.0


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

    1 download

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


    For loop examples Profit loss example

  • Create New...