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("http://testdrive.sharepoint.mysite.com/teams/clab/" & "_layouts/viewlsts.aspx?BaseType=0", _
"NewLists "), True
End Sub

Thanks
ASKER CERTIFIED SOLUTION
colly92002

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