Can't create new items in SharePoint list

[sirhacksalot]

I have the following code in an Excel macro that I have gathered from other sources to use SOAP to update an existing SharePoint List. Everything runs fine and I have set it up to display a message box with the status and I get status 200 or "Ok". However the new list item never shows on the list. Any help with this?

Please Login or Register  to view this content.

Thanks in advance!

[sirhacksalot]

I solved it. And here is what I learned...

1. Check status of code: Declaring a new DOMDocument, i.e. XMLDOC, and then adding XMLDOC.LoadXML responseText at the end of the code is a lot more helpful in finding the status of the code and what is going wrong.
2. Field Names: The column name displaying in the SharePoint List or even in the list settings is not necessarily the column name that SharePoint uses. The best way to find the actual column name used by SharePoint is to go the List's settings, click a column to edit and once the new screen loads, grab everything in the URL after "Field=". You will need to URL decode the string. i.e. The URL will be "https://...&Field=Column%5Fx0020%5FName" and you will need to place "Column_x0020_Name" that into the vba code - <Field Name='Column_x0020_Name'>
3. List GUID: I changed the list GUID string in the above code from the actual name to the GUID of the list xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx
4. Method ID Tag: changed it to 1 instead of 3 listed above

Working code:

Please Login or Register  to view this content.