Push data from Excel 2013 table to linked SharePoint 2013 list using VBA.

[gklewis83]

I have attempted to use the below VBA code to push updates from an Excel table that is linked to a SharePoint list.

Sub UpdateSPList()     Dim ws As Worksheet     Dim objListObj As ListObject     Set ws = ThisWorkbook.Worksheets(1)     Set objListObj = ws.ListObjects("MITSC_ProductList")     objListObj.UpdateChanges xlListConflictDialog End Sub

Unfortunately, it seems that "UpdateChanges" is not longer an available method; thus, my question is: How do I push an update now? I have Google searched everything from "excel 2013 vba" update "sharepoint 2013" list to anything else that I could think of (including my title for this request), and I'm surprised to say that even recently updated forums only have answers that work with Excel 2010 (or in some cases earlier). Any help would be appreciated. Thank you for your time! Respectfully sent, gklewis83

 

[AliGW]

Cross-posted here: Push data from Excel 2013 table to linked SharePoint 2013 list using VBA.

 

[gklewis83]

Thank you, AliGW! I did that in the "LinkBacks" field, but I don't see it displayed... :\

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Just post the link right in your thread/question.