Hi,

I wish I could update the Share Point List From Excel using VBA as I feel more comfortable working on Excel than Share Point.

I use below code to import the share point list data to Excel, is working fine
Please Login or Register  to view this content.
I have below peace of code to update the Share Point List, but unfortunately its not working at all 
Please Login or Register  to view this content.
When I execute the above code I get at last code line

"Run-time error'-2147467259 (80004005)':
An unexpected error has occurred. Changes to your data cannot be saved"

Can some one please help me in this. Thank you