troubleshooting Question

Excel Vba Publish filtered data to SharePoint

Avatar of alanpowell2007
alanpowell2007Flag for United States of America asked on
Visual Basic ClassicMicrosoft ExcelMicrosoft SharePoint
3 Comments1 Solution1298 ViewsLast Modified:
I am having trying to publish filtered excel (2007) data to sharepoint. I keep getting an error that says that one table can't overlay another. Am I going about selecting the range wrong? Here is the code:

Public Sub PublishList()
' Get the collection of lists for the active sheet
Dim L As ListObjects
Set L = ActiveSheet.ListObjects
' Add a new list
Dim NewList As ListObject
Set NewList = L.Add(xlSrcRange, Range("A13:K29"), , True)
NewList.Name = "Red Team Review Metrics"
' Publish it to a SharePoint site
NewList.Publish Array("" & "_layouts/viewlsts.aspx?BaseType=0", _
"NewLists "), True
End Sub


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros