MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Sub CreateReport(strpath As String) Dim Objdoc As Object Dim Wks As Excel.Worksheet Set Objdoc = GetObject(strpath, "Word.Document") Set Wks = ThisWorkbook.Sheets(1) 'An example of how I use the code to manipulate the Word file Objdoc.Tables(1).Range.Rows.last.Delete Set Objdoc = Nothing Set Wks = Nothing End Sub
|How do you check for multiple possibilities in Excel||7||27|
|Macro to delete rows where col 14 and 16 contain blank cells||10||21|
|Index Match Formula VBA||6||21|