Whatsapp Desktop Automation with VBA @Exceltrainingvideos
Whatsapp Desktop Automation with VBA  @Exceltrainingvideos
Uploaded October 2020 | Updated September 2026, 2 weeks ago
How to automate Whatsapp Desktop to login, search for user, send message and attachment and logout.
Here's the complete macro or VBA code:
Option Explicit
Dim driver As New WebDriver
Sub LoginSearchUserSendMessageAttachmentViaWhatsapp()
'Chrome Driver
'Selenium
'Selenium Wrapper

Dim keys As New SeleniumWrapper.keys
Dim filepath As String

filepath = "C:\exceltrainingvideos-12\find-header-with-todays-date.xlsm"

driver.Start "chrome"
driver.Get "web.whatsapp.com/"
driver.Window.Maximize

driver.Wait 5000

'driver.Wait 2000
driver.FindElementByXPath("//span[@title = 'Dt']").Click
driver.Wait 1000
driver.SendKeys (keys.Tab + keys.Tab)
driver.Wait 1000
driver.SendKeys ("Poonam Mobile")
driver.Wait 1000
driver.SendKeys (keys.Enter)


driver.FindElementByClass ("_3FRCZ")
driver.SendKeys ("Please study *the below attached file* for the class tomorrow.")
driver.Wait 1000
driver.SendKeys (keys.Enter)

driver.Wait 2000
driver.FindElementByXPath("//div[@title='Attach']").Click

driver.Wait 10000
driver.FindElementByXPath("//input[@accept='image/*,video/mp4,video/3gpp,video/quicktime']").SendKeys (filepath)

driver.Wait 2000 ' this wait time depends on the size of your file max 64 mb
driver.FindElementByXPath("//span[@data-icon = 'send']").Click

driver.Wait 1000
driver.FindElementByXPath("//div[@title = 'Menu']").Click
driver.FindElementByXPath("//div[@title='Log out']").Click

driver.Quit

End Sub
Whatsapp Desktop Automation with VBAFind Specific Word in TextClean Data Using Flash Fill in ExcelAPIs in Excel. No VBA. Use Power Query.Text To Columns Using Macro in ExcelCopy Charts from Excel to PowerPoint Automatically2021 | Shorts | Quick Inventory Management No VBAWhat is  Modeless UserFormAutomatically Prevent Printing of ShapesGet Data from Contacts Folder in Outlook Automatically | 2021Track Changes in Excel Worksheet Without VBAPrint Only Hidden Worksheets Automatically
Dinesh Kumar Takyar |

Whatsapp Desktop Automation with VBA

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER