Relative Content

Tag Archive for excelvbalistobject

Filter in list object, Power Query, VBA

I have a simple code to grab the data from a SharePoint list, and due to the large amount of data, it takes plenty of time to refresh this query, I am using “Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False”.
My question is: can I filter the data based on its creation date, where the column is called “Created” in the SharePoint List.
The full code is available if needed. And thank you in advance.