Whatsapp Desktop Automation with VBA
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 "https://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 VBA канала Dinesh Kumar Takyar
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 "https://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 VBA канала Dinesh Kumar Takyar
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Step by step using Selenium VBA to send whatsapp (Chrome Automation)Automatically Send Message with Image Via WhatsappForward Message via whatsapp DesktopHow To Send WhatsApp Messages From Excel Using VBA (Free & Easy) 📲Automatically send multiple messages via whatsapp to multiple contacts with Phone numbersFrom Google Sheet to Whatsapp ( No add ons. Completely free)Excel Get Data From Closed Workbooks VBA - part 2Send WhatsApp Messages From Excel With VBA Using Twilio | Step-by-Step Tutorial 💬How to create WHATSAPP Bot using VBScript(Send unlimited WHATSAPP messages FREE of COST)Automate Image PDF Videos Upload Via WhatsAppPing & Send WhatsApp Message to your Phone | Microsoft Excel VBASend Whatsapp Message from Excel Sheet through VBAHow to send WhatsApp messages using VBA code | Advanced VBA in HindiList Files in Folder Create HyperlinkAutomate WhatsApp message || Hack WhatsApp || WhatsApp trick || Learn Python || Python ProjectHow To Send SMS Messages From Excel With VBA | Step-by-Step Tutorial 💬Send Whatsapp messages by upload excel file contacts using google chrome extensionFully Automated Data Entry User Form in Excel - Step By Step TutorialSend Whatsapp Message Using Python - WithOut Any API (Whatsapp Automation Tutorial)