Moshe Singer
asked on
to transfer string from C lanaguage to VBA
I would like to transfer the following code, written in C language, to VBA.
Dim username As String
Dim pin As String
Dim broadcastType As String
Dim phoneNumberSource As String
Dim broadcastName As String
Dim checkCallingWindow As String
Dim commaDelimitedPhoneNumbers As String
Dim TTSText As String
username = "999111999"
pin = "9991"
broadcastType = "1"
phoneNumberSource = "3"
broadcastName = "Test from Visual Basic"
checkCallingWindow = "0"
commaDelimitedPhoneNumbers = "9725551313"
TTSText = "Hello, This is a text to speech call testing integration with Microsoft Access 2016. Have a nice day."
Dim SoapPost As String
I would appreciate help in transferrring the above string to VBA or to VB.net.
Thank you in advance.
Dim username As String
Dim pin As String
Dim broadcastType As String
Dim phoneNumberSource As String
Dim broadcastName As String
Dim checkCallingWindow As String
Dim commaDelimitedPhoneNumbers
Dim TTSText As String
username = "999111999"
pin = "9991"
broadcastType = "1"
phoneNumberSource = "3"
broadcastName = "Test from Visual Basic"
checkCallingWindow = "0"
commaDelimitedPhoneNumbers
TTSText = "Hello, This is a text to speech call testing integration with Microsoft Access 2016. Have a nice day."
Dim SoapPost As String
SoapPost = "<?xml version=""1.0"" encoding=""utf-8""?> <soap12:envelope "
xmlns: xsi = ""http://www.w3.org/2001/XMLSchema-instance""
xml2ns: xsd = ""http://www.w3.org/2001/XMLSchema""
xmlns:soap12="&quot;http://www.w3.org/2003/05/soap-envelope&quot;">"_
& "<soap12:body>" _
& "<" & FunctionName & " xmlns=""http://call-em-all.com/"">" _
& " <myRequest>" _
& " <username>" & username & "</username>" _
& " <pin>" & pin & "</pin>" _
& " <phoneNumberSource>" & phoneNumberSource & "</phoneNumberSource>" _
& " <broadcastName>" & broadcastName & "</broadcastName>" _
& " <broadcastType>" & broadcastType & "</broadcastType>" _
& " <checkCallingWindow>" & checkCallingWindow & "</checkCallingWindow>" _
& " <commaDelimitedPhoneNumbers>" & commaDelimitedPhoneNumbers & "</commaDelimitedPhoneNumbers>" _
& " <TTSText>" & TTSText & "</TTSText>" _
& " </myRequest>" _
& "</" & FunctionName & ">" _
& "</soap12:Body>" _
& "</soap12:Envelope>"
I would appreciate help in transferrring the above string to VBA or to VB.net.
Thank you in advance.
ASKER
I tested, it cannot be compiled from the debug menu
it is full with errors
it is full with errors
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
now it is error free
I have to test if it is working
Thanks a milion
I have to test if it is working
Thanks a milion
Open in new window