Soap Ovh In Excel Vba
Hi,
I would like to convert a script php5 in VBA excel.
My situation:
I have a formular in html and it is using to send an email.
When I click on the bouton “send”, the script send.php5 run.
send.php5:
<?php
$nic=”xx123456-ovh”;
$pass=”ovh123456″;
$sms_compte=”sms-xx123456-1″;
$from=”+336666666″;
$to=$HTTP_POST_VARS['destinataire'];
$message=$HTTP_POST_VARS['texte'];
try
{
$soap = new SoapClient(“https://www.ovh.com/soapi/soapi-re-1.8.wsdl”);
$session = $soap->login(“$nic”, “$pass”,”fr”, false);
echo “login successfulln”;
$result = $soap->telephonySmsSend($session, “$sms_compte”, “$from”, “$to”, “$message”, “”, “1″, “”, “”);
echo “telephonySmsSend successfulln”;
print_r($result);
$soap->logout($session);
echo “logout successfulln”;
}
catch(SoapFault $fault)
{
echo “Problem” ; //$fault;
}
?>
The job:
I would like in one sheet in Excel a formular:
Exemple: range(“A1″).value = “+33612345678″ (phone number)
range(“A2″).value = “the text to send”
I need a button to run a VBA program in Excel:
The VBA will be the translation of send.php5.
The result of the send will be in other sheet.
Regards
