Word VBA

You need a Word macro that saves your document automatically with a filename that follows a specific pattern such as ProjectName_Date_Version.docx. The built-in AutoRecover feature in Word does not allow custom filenames and saves only to a fixed location. This article explains how to write a VBA macro that creates a custom filename from document … Read more

You run a VBA macro in Word and it stops partway through, always at the same document operation such as a FindReplace, a TableSort, or a Range.Insert. This symptom points to a runtime error that the default error handler does not catch, or to a condition that triggers Word’s built-in protection. The root cause is … Read more

You need to apply the same conditional formatting rules to every table in a Word document, but doing it manually for dozens or hundreds of tables is impractical. Word does not have a built-in conditional formatting feature like Excel, so you must use VBA to automate the task. This article explains how to write and … Read more

You run a Word VBA macro that uses Selection.TypeText to insert text into a specific bookmark, but the text ends up outside the bookmark or in the wrong range. This often happens because Selection.TypeText does not respect the bookmark range when the selection is not explicitly set to the bookmark. The root cause is that … Read more

Document properties in Word store metadata such as author name, title, subject, keywords, and last-saved date. You may need to extract this information automatically when processing multiple files or generating reports. The built-in document properties panel shows this data, but reading it with a VBA macro lets you collect it in bulk or use it … Read more

When you insert multiple high-resolution images into a Word document, the file size can grow rapidly, making it difficult to share or store. Word does not offer a built-in one-click command to compress all images at once before saving. You can use a VBA macro to automate bulk image compression, reducing file size without manually … Read more

You write a VBA macro in Word that stores a reference to a document, range, or table. After you close and reopen the document, the object variable no longer points to the expected object. This happens because VBA object variables are stored in memory and do not persist across document sessions. When you reopen the … Read more

If you have Word VBA macros that automate document tasks, they run only in the desktop app. Office Scripts work in Word for the web and Microsoft 365 cloud environments. This article explains the key differences between VBA and Office Scripts and provides a step-by-step migration process. You will learn how to rewrite common VBA … Read more

You have a Word document with bookmarks that are not visible in the default Bookmarks dialog or in the document body. These hidden bookmarks may reside in headers, footers, text boxes, comments, or other story ranges. The standard ActiveDocument.Bookmarks collection only covers the main document story. To access all bookmarks, you must use VBA to … Read more

You see Word VBA Error 91: Object Variable or With Block Variable Not Set when your macro tries to access a specific ContentControl. This error occurs because the code references a ContentControl object that does not exist, has not been assigned, or has been released from memory. The macro attempts to use an object variable … Read more