Creating a Complex Array with Defined Structure (SOAP)

[frolicols]

I am trying to create an array with defined elements. I have a class file called struct_message:

Public originator As String
Public recipient As String
Public body As String
Public messagetype As String
Public validityperiod As Long

I then wish to create an array object an assign the various elements to each index. Is this correct? My current code is:

Sub BuildArray()

Dim aMessages() As struct_message

For i = 1 to 5

aMessages(i).originator = "Test"
aMessages(i).recipient = "Someone's Name"  'This will be changed to cycle through the recipients
aMessages(i).body = "The Message" 'This will be changed to cycle through individual messages
aMessages(i).messagetype = "Text"
aMessages(i).validityperiod = 0

Next i

End Sub

When I run the code I'm getting a Subscript Out of Range error. This is for use to upload using a SOAP service. Any ideas why I can't assign the indexed elements?

 

[Andrew Poulsom]

Check out the Type statement in VBA Help. Here is a video (you may want to turn the sound off).

http://www.youtube.com/watch?v=9c6yEchyE4c

 

[RoryA]

You haven't declared the size of your array, hence you cannot assign anything to it.

 

[frolicols]

OK I've managed to tidy up my code and it now works in that it creates a variant array with elements defined by my struct_message class file.

After all this, the problem I've now found out is the SOAP Toolkit code does not like complex arrays! Apparently I need to turn my complex array into a simple one using the MSXML Parser.

I've found an example here:

http://msdn.microsoft.com/en-us/library/aa140267(v=office.10).aspx#odc_wsrtct_parsing

This example takes a simple array input and parses a complex array as an output. I need it the other way round (complex array input, simple 1d array output).

How do I pass information into IXMLDOMNodeList and IXMLDOMNode?