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 [login to view URL] run.
[login to view URL]:
<?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("[login to view URL]");
$session = $soap->login("$nic", "$pass","fr", false);
echo "login successfull\n";
$result = $soap->telephonySmsSend($session, "$sms_compte", "$from", "$to", "$message", "", "1", "", "");
echo "telephonySmsSend successfull\n";
print_r($result);
$soap->logout($session);
echo "logout successfull\n";
}
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