Extract Specific Data from MS Word into Excel with VBA @Exceltrainingvideos

Uploaded February 2019 | Updated September 2026, 1 week ago

How to extract specific data from MS Word into Excel with VBA automatically.
A sample file for download is available at this link:
exceltrainingvideos.com/extract-specific-data-from-ms-word-into-excel-with-vba

Convert Excel Charts to Images Automatically

2021 | Recover Data From Protected Excel File| | Using Google Sheets

Create Data Entry Forms under 10 seconds No VBA

Calculate Change Percentage Automatically as you Type

$Automatically Send Message with Image Via Whatsapp How to automatically send message with image via Whatsapp using VBA. Heres the complete VBA code: Option Explicit Sub SendMessageWithPicViaWhatsapp() Dim ie As InternetExplorer Set ie = New InternetExplorer Dim mytext As String Dim myDir As String mytext = Sheet1.Range(C2) Dim myObj Dim Pictur Set myObj = ActiveSheet.DrawingObjects For Each Pictur In myObj If Left(Pictur.Name, 7) = Picture Then Pictur.Select Pictur.Delete End If Next Dim EmployeeName As String, T As String myDir = C:UserstakyarPicturesemployees EmployeeName = Range(A2) & Range(B2) T = .jpg On Error GoTo errormessage: EmployeeName = Range(A2) & Range(B2) ActiveSheet.Shapes.AddPicture Filename:=myDir & EmployeeName & T, linktofile:=msoFalse, _ savewithdocument:=msoTrue, Left:=240, Top:=15, Width:=60, Height:=60 errormessage: If Err.Number = 1004 Then MsgBox File does not exist. & vbCrLf & Check the name of the employee! Range(A2).Value = Range(B2).Value = End If ActiveSheet.Shapes(1).Copy ie.navigate https://web.whatsapp.com/send?phone=919810081867&text= & mytext Application.Wait (Now + TimeValue(00:00:10)) Call SendKeys(^v) Call SendKeys({ENTER}, True) Application.Wait (Now + TimeValue(00:00:05)) Call SendKeys({ENTER}, True) End Sub Refer to this video on how to add an appropriate image to a worksheet: https://www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/$

Super Quick Method to UNSTACK One Column of Data into Multiple Columns

Create Dynamic User Form with two Dependent Combo Boxes

Dinesh Kumar Takyar |

Extract Specific Data from MS Word into Excel with VBA