What is the best way to find documents with macros

Alison Slater 80 Reputation points
2025-02-10T06:34:08.7666667+00:00

What is the best way to find documents in a SharePoint library and / or site that contain Macros? So far, I have only been advised or found information on running a PowerShell script example Reference: GitHub - junecastillote/SPO-File-Search: PowerShell script to find files in a SharePoint Online and OneDrive sites.

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,287 questions
0 comments No comments
{count} votes

Accepted answer
  1. Xyza Xue_MSFT 28,221 Reputation points Microsoft Vendor
    2025-02-10T08:10:17.9833333+00:00

    Hi @Alison Slater ,

    Unfortunately, there is no built-in feature in SharePoint 2013 that provides a direct report listing all documents with macros. The PowerShell approach remains the most viable method for automation and efficiency.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Alison Slater 80 Reputation points
    2025-02-10T21:30:36.38+00:00

    Xyza Xue, thank you for your prompt response. I will look at PowerShell to provide a report.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.