Featured Post

Add Fixed Size Images in Excel

0

Send Whatsapp Message from Excel VBA Step by Step Tutorial

Ever thought how to send WhatsApp messages from computer using excel. If you don't know just have a look and make applications according to your choice and send a message or text from excel without re-writing all the data.

Watch Below video for complete tutorial. 

#computertechtutorials #computertech #whatsappmessagefromexcel

Comments

  1. UnknownJuly 17, 2020 at 5:50 AM

    pls send the code

    ReplyDelete
  2. testDecember 26, 2020 at 5:48 AM

    Private Sub Msg_Btn_Click()

    Dim text As String
    Dim Contact As String

    Contact = ActiveSheet.Range("A2").Value 'copy from cell contact number
    text = ActiveSheet.Range("B2").Value 'copy from cell text number


    ActiveWorkbook.FollowHyperlink Address:=" https://web.whatsapp.com/"
    'Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" & " https://web.whatsapp.com/"
    Application.Wait (Now + TimeValue("0:00:20")) 'depends upton internet speed you can decrease it if whatsapp page opens quickly

    Call SendKeys("{TAB}", True) 'for search option in whatsapp This line of code will press TAB button of keyboard thorugh program
    Application.Wait (Now + TimeValue("0:00:01")) ' wait 1 sec is enough
    Call SendKeys(Contact, True) 'write contact name in whatsapp search option
    Application.Wait (Now + TimeValue("0:00:02")) 'wait time
    Call SendKeys("~", True) ' press enter
    Application.Wait (Now + TimeValue("0:00:02"))
    Call SendKeys(text, True) ' write message to mentioned contact person
    Application.Wait (Now + TimeValue("0:00:02"))
    Call SendKeys("~", True)

    End Sub

    ReplyDelete
  3. pkApril 23, 2021 at 2:00 AM

    With this, only one WhatsApp message is sent. What to do if you want to post a message on a lot of WhatsApp?

    ReplyDelete

Post a Comment