Hi,
I have a pretty large sharepoint list (~70K rows). I have some VBA to download the entire list to Excel (below). The only problem is that it takes quite a while to pull down the entire list.
I'm wondering if there is any way I can pull down only the rows which meet certain conditions (eg column 2 >0, column 3>Today). Any thoughts?
I have a pretty large sharepoint list (~70K rows). I have some VBA to download the entire list to Excel (below). The only problem is that it takes quite a while to pull down the entire list.
I'm wondering if there is any way I can pull down only the rows which meet certain conditions (eg column 2 >0, column 3>Today). Any thoughts?
Code:
ActiveSheet.ListObjects.Add SourceType:=xlSrcExternal, _
Source:=Array("http://sharepoint/_vti_bin", "List Name", _
"{XXXXXXXX-XXXX-XXXX-XXXX-59BBE54DE7D7}"), LinkSource:=True, Destination:=Range("A1")
