VBA coding needed for intergration of SMS gateway API

I have web base SMS gateway API in order to send results from Excel sheet.

SMS gateway provider give me VB6 code of API. Now i want to integrate this in Excel Macro VBA. When i click send results then code automatically pick values from Excel sheet and send results to given numbers on Excel sheet.
Aamir HussainAsked:
Who is Participating?
 
Ryan ChongCommented:
in general, we use XmlHttpRequest object in VBA environment to send a web request.

so, in your Excel's send action, you probably need to do a loop to check for cell values, and then send the web request once per line.

the content to be sent to SMS gateway is depending on what is specified at SMS gateway side.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.