+ Reply to Thread
Results 1 to 10 of 10

Send message to myself in WhatsApp form Excel VBA

  1. #1
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Send message to myself in WhatsApp form Excel VBA

    I'm trying to see if I can add some code that will send my own number a message in whatsapp at the end of some VBA code I'm running, as it can take a long time and I don't stay at my PC while it's running.
    Is this possible please?
    My googling hasn't really found any answers so far

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Send message to myself in WhatsApp form Excel VBA

    Have you tried the status bar?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118
    Quote Originally Posted by xladept View Post
    Have you tried the status bar?
    Not sure what you mean

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Send message to myself in WhatsApp form Excel VBA

    Anywhere in your code you can put things like:

    Application.StatusBar "Macro is running - it's about " & q & " Percent done"

    or whatever. And it will show on wherever your status bar resides

  5. #5
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Send message to myself in WhatsApp form Excel VBA

    I was more interested in being able to send the whatsapp message

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Send message to myself in WhatsApp form Excel VBA

    I've forwarded your thread to the rest of the forum since I don't play on social media.

  7. #7
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Send message to myself in WhatsApp form Excel VBA

    Maybe begin from the start?
    Why does your code run so long?
    Then
    do you use Outlook? it is much easier to send a message through it

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Send message to myself in WhatsApp form Excel VBA

    You can't; Whatsapp can only send messages via your phone. A text would be viable, but you can't send an unattended whatsapp

  9. #9
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Send message to myself in WhatsApp form Excel VBA

    I'm not worried about the code taking so long to run, I just wanted a message when it had finished, I don't use Outlook, can an email be sent without it, or open to trying text message.
    thanks all

  10. #10
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send message to myself in WhatsApp form Excel VBA

    probably not the best site for this kind of advice
    https://stackoverflow.com/questions/...ogrammatically
    you could possibly emulate or some other hack but TOS agreement and all...so suggest against it

    https://www.whatsapp.com/legal/?doc=...rsion=20120707
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. send whatsapp messages from excel
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2019, 04:14 PM
  2. [SOLVED] Macro to send e-mail from excel doesn't insert body of message
    By Ramzes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2019, 07:03 AM
  3. Excel VBA To Web.whatsapp.com
    By chhiew in forum Excel General
    Replies: 19
    Last Post: 10-12-2018, 05:07 AM
  4. Excel VBA to Web.Whatsapp
    By chhiew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2017, 02:23 AM
  5. Macro to send Instant Message from excel to Yahoo messanger
    By praveensverma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2013, 12:43 PM
  6. How to send a range of cells in a sms text message by using VB -Applications in Excel
    By g00glethis1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-06-2009, 06:32 PM
  7. [SOLVED] send a outlook template message from excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1