Avatar of Russellbrown
Russellbrown
Flag for United States of America asked on

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

Hi,

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.
Microsoft SharePointMicrosoft Excel

Avatar of undefined
Last Comment
Russellbrown

8/22/2022 - Mon
ScriptAddict

ASKER CERTIFIED SOLUTION
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Russellbrown

ASKER
Thank you for the prompt response.
Russellbrown

ASKER
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck