Link to home
Start Free TrialLog in
Avatar of Russellbrown
RussellbrownFlag for United States of America

asked on

How to Use Excel VBA to Obtain Number of Items In A SharePoint List?


I am able to obtain the Name of List and GUID of a SharePoint List  using Excel VBA e.g.
 listName = xmlNode.Attributes.getNamedItem("Title").Text
 listGuid = xmlNode.Attributes.getNamedItem("ID").Text

What will be the syntax to obtain the number of items/records  in a said list?

Thank you.
Avatar of ScriptAddict
Flag of United States of America image

Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Russellbrown


Thank you for the prompt response.
Hi Customer Advocate ,

I like to award full points to both ScriptAddict and Rainer, but the system does not allow it. How can I award points to ScriptAddict?. Thank you.