Downloading SharePoint list attachments via VBA

[Raju Mohan]

I am trying to build a spreadsheet macro, which is based on the below mentioned steps.

1) Takes the list ID number of a SharePoint form from the user via input box.
2) Creates a folder name based on this ID number (originally captured by the input box)
3) Retrieves all the attachments stored within that particular SharePoint form via the list ID.

I am not very good with VBA.

If someone could help me out with this piece of code, it would be really helpful for me.

Thank you,
Mohan