devxlogo

Zap Expired Docs

Zap Expired Docs

This VBA Microsoft Word routine purges a document when it’s opened after a predefined expiration date. I’ve only tested this macro with Word 97:

 Sub Purge()	Dim ExpirationDate As Date	ExpirationDate = #4/1/98#	'This particular document expires on 1 April 1998	If Date >= ExpirationDate Then		'Purge the document		With Selection			.WholeStory			.Delete Unit:=wdCharacter, Count:=1			.TypeText Text:= _				"This document expired on" & _				Str(ExpirationDate) & "."			.TypeParagraph		End With		ActiveDocument.Save		'Alert the user		MsgBoxResult = MsgBox("This document has expired. " _			& "Please acquire an updated copy.", , _			"Document Purge")	End IfEnd Sub

In order to work, you should call this macro from a document’s AutoOpen macro.

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist