none
A string from API or HTML or XML be transferred to VBA RRS feed

  • Question

  • How can a  string from API or HTML or XML be transferred to VBA

    Dim SoapPost As String

        SoapPost = "<?xml version=""1.0"" encoding=""utf-8""?> <soap12:envelope "
    xmlns:            xsi = "&quot;http://www.w3.org/2001/XMLSchema-instance&quot;"
    xmlns:            xsd = "&quot;http://www.w3.org/2001/XMLSchema&quot;"
          xmlns:soap12="&amp;quot;http://www.w3.org/2003/05/soap-envelope&amp;quot;">&quot;_
        & "<soap12:body>" _
        & "<" & FunctionName & " xmlns="&quot;http://call-em-all.com/&quot;">" _
        & " <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>"


    • Edited by Moshe Singer Thursday, October 27, 2016 5:26 PM
    • Moved by Neda Zhang Friday, October 28, 2016 2:24 AM related to vba
    Thursday, October 27, 2016 5:22 PM

All replies

  • How can a  string from API or HTML or XML be transferred to VBA

    Dim SoapPost As String

        SoapPost = "<?xml version=""1.0"" encoding=""utf-8""?> <soap12:envelope "
    xmlns:            xsi = "&quot;http://www.w3.org/2001/XMLSchema-instance&quot;"
    xmlns:            xsd = "&quot;http://www.w3.org/2001/XMLSchema&quot;"
          xmlns:soap12="&amp;quot;http://www.w3.org/2003/05/soap-envelope&amp;quot;">&quot;_
        & "<soap12:body>" _
        & "<" & FunctionName & " xmlns="&quot;http://call-em-all.com/&quot;">" _
        & " <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>"



    Friday, October 28, 2016 12:51 AM
  • Did you ever think about using a text file? After all a text file is container and HTML and XML is just string data.
    Friday, October 28, 2016 12:53 AM
  • Hi Moshe Singer,

    Since this forum is discussing and asking questions about the Visual Basic programming language, IDE, libraries, samples, and tool, and your issue is more related to VBA, I will move this thread to the more related forum.

    Reference: https://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba&filter=alltypes&sort=lastpostdesc

    Thanks for your understanding and support.

    Best Regards,

    Neda Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, October 28, 2016 2:24 AM