VBA (Visual Basic for Applications) macros are small programs that can be embedded within Microsoft Word documents to automate repetitive tasks, add interactivity to documents, and perform other useful functions. While macros can be beneficial in many situations, they can also pose a security risk if the code is malicious or contains malware. By removing VBA macros from Word documents, you can reduce the risk of security breaches and malware infections. In this article, you will learn how to detect and remove VBA macros from Word documents in C# and VB.NET using Spire.Doc for .NET library.

Install Spire.Doc for .NET

To begin with, you need to add the DLL files included in the Spire.Doc for .NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.

PM> Install-Package Spire.Doc

Detect and Remove VBA Macros from Word Documents in C# and VB.NET

You can use the Document.IsContainMacro property to detect whether a Word document contains VBA macros. If any macros are detected, you can use the Document.ClearMacros() method to easily remove them from the document.

The following steps show how to detect and remove VBA macros from a Word document using Spire.Doc for .NET:

• Initialize an instance of the Document class.
• Load a Word document using the Document.LoadFromFile(string fileName) method.
• Detect if the document contains VBA macros using the Document.IsContainMacro property.
• If any macros are detected, remove them from the document using Document.ClearMacros() method.
• Save the result document using Document.SaveToFile(string fileName, FileFormat fileFormat) method.

using Spire.Doc;

namespace RemoveVBAMacros
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Document class
            Document document = new Document();
            //Load a Word document
            document.LoadFromFile("Input.docm");

            //Detect if the document contains macros
            if (document.IsContainMacro)
            {
                //Remove the macros from the document
                document.ClearMacros();
            }

            //Save the result document
            document.SaveToFile("RemoveMacros.docm", FileFormat.Docm);
            document.Close();
        }
    }
}

Imports Spire.Doc

Namespace RemoveVBAMacros
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Document class
            Dim document As Document = New Document()
            'Load a Word document
            document.LoadFromFile("Input.docm")

            'Detect If the document contains macros
            If document.IsContainMacro Then
                'Remove the macros from the document
                document.ClearMacros()
            End If

            'Save the result document
            document.SaveToFile("RemoveMacros.docm", FileFormat.Docm)
            document.Close()
        End Sub
    End Class
End Namespace

Apply for a Temporary License

If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself.