+ Reply to Thread
Results 1 to 6 of 6

sending sms from excel vba

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    cameroun
    MS-Off Ver
    office 2007
    Posts
    37

    sending sms from excel vba

    I have a working excel vba program, which allows to invoice the services and to take the appointments of the customers. I would like that each time an invoice is issued, the customer receives a thank you message for the amount of the invoice by sms. Also when a client's appointment is recorded, he gets an acknowledgment of receipt.

    A similar problem has already been dealt with here. However there are items below that I did not understand in this code.

    My knowledge of vba is really basic. Can you help me please.

    Below is the code, as well as the lines which I don't understand.
    thank you in advance



    THE CODE

    Please Login or Register  to view this content.



    The lines i dont understand

    Please Login or Register  to view this content.
    Last edited by alansidman; 10-08-2020 at 05:58 AM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,689

    Re: sending sms from excel vba

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,835

    Re: sending sms from excel vba

    so the (xyz as integer) is basically telling the Subroutine to take whatever value is passed into it and place it in a variable called "xyz".

    those 3 lastrow lines are working out what the last populated row is in the first 3 sheets of the workbook. Basically to make it better code rather than doing loops to say 100000 or something and then weeding out blank rows.

    That last line appears to be taking a value from a form (frmmain) and then doing something with it. A lot of that code will be different for yours. The important bit you need is the bit following the Else statement that's where the SMS magic happens.

    Just a quick daft question though, you do have an account with a relevant SMS provider set up etc? you'll need that before you can do anything.
    If someone has helped you then please add to their Reputation

  4. #4
    Registered User
    Join Date
    10-01-2020
    Location
    cameroun
    MS-Off Ver
    office 2007
    Posts
    37

    Re: sending sms from excel vba

    Merci Alansidman, c'est compris

  5. #5
    Registered User
    Join Date
    10-01-2020
    Location
    cameroun
    MS-Off Ver
    office 2007
    Posts
    37

    Re: sending sms from excel vba

    Merci. Je vais poster par la suite ce que j'ai codé et vous me direz si cela tien la route svp.
    Quant au fournisseur, je suis en pourparler avec les fournisseurs. Je me suis inscrit sur quelques plateformes où certains m'ont fournit les informations relatives à l'appel de leur API.

  6. #6
    Registered User
    Join Date
    10-01-2020
    Location
    cameroun
    MS-Off Ver
    office 2007
    Posts
    37

    Re: sending sms from excel vba

    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 01-08-2016, 09:57 AM
  2. sending sms from excel?
    By Johnny247 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2015, 10:10 PM
  3. Copying content of one excel to another excel and sending email with excel data
    By archies.gall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2012, 02:22 PM
  4. Something out of the Purview of Excel-Sending Excel table as a body in an Email?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2011, 07:50 AM
  5. [SOLVED] Sending SMS from Excel
    By Piotr in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 06:00 AM
  6. Sending fax from Excel
    By Bogdan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2005, 11:05 AM
  7. Replies: 0
    Last Post: 04-02-2005, 09:06 AM

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