Excel → Word → PDF Workflow for Compliance Evidence Packs
Build one reviewed compliance case into several different Word and PDF documents with an exact template register, controlled input snapshots, and a separate release review.
Quick answer: separate the case from the document register
Keep one reviewed control case in EvidenceCase. List the different pack documents in DocumentRegister. Each APPROVED row declares its own Word template, output suffix, exact bookmark contract, and optional evidence image.
The VBA example creates several case documents and can embed approved images. Original policies, logs, exports, tickets, emails, PDFs, access histories, hashes, and retention records remain in the authorized evidence repository.
Define the evidence pack scope before building templates
Control scope
Identify the exact control, process, system boundary, entity, and review period covered by the pack.
Framework reference
Record the approved framework, policy, contract, or internal requirement without claiming the macro interprets it.
Evidence ownership
Name the control owner and the reviewer responsible for the supplied narrative and referenced evidence.
Document set
Decide which different documents belong in the pack and which original artifacts remain outside it.
Approval gate
Define who approves source content, templates, evidence images, the generated pack, and final submission.
Retention and access
Set storage, permissions, versioning, audit logging, retention, and incident-response rules separately.
Create one EvidenceCase row in columns A–I
A — PackID
Unique Windows-safe identifier for the generated pack.
B — ControlID
Stable identifier for the reviewed control or requirement.
C — OrganizationName
Reviewed organization or entity name used throughout the documents.
D — ReviewPeriodDisplay
Document-ready review period text.
E — FrameworkName
Approved framework, policy, contract, or control-set label.
F — ControlOwner
Optional in the case row but required when a template declares that bookmark.
G — ControlNarrative
Approved narrative covering scope, operation, evidence reference, exception, and conclusion as appropriate. Excel line breaks are preserved as separate Word paragraphs.
H — ReviewerName
Reviewed name; the macro does not verify authority or signature.
I — PackStatus
Use exactly READY, HOLD, or DONE. READY is required for generation.
Use DocumentRegister for the different pack documents
A — DocumentKey
Unique register key such as COVER, NARRATIVE, EVIDENCE_IMAGE, or ACTION_SUMMARY.
B — TemplateFile
Unique approved DOCX filename stored in Templates.
C — OutputSuffix
Unique Windows-safe suffix appended to PackID.
D — RequiredBookmarks
Case-sensitive semicolon-separated list of the allowed bookmarks used by that template.
E — EvidenceImageFile
Optional filename in Assets\EvidenceImages; required only when the contract includes EvidenceImage.
F — DocumentStatus
Use exactly APPROVED or RETIRED. Only APPROVED rows are generated.
Every APPROVED template must declare PackID, ControlID, and OrganizationName. Other allowed bookmarks are ReviewPeriodDisplay, FrameworkName, ControlOwner, ControlNarrative, ReviewerName, and EvidenceImage.
Make every Word template declare its exact contract
Cover sheet
May use pack identity, organization, review period, framework, owner, and reviewer.
Control narrative
May use the identity fields plus ControlNarrative and ReviewerName.
Evidence image sheet
May use pack identity plus one controlled EvidenceImage.
Action summary
May use identity, owner, narrative, review period, and reviewer fields.
Exact declarations
The macro rejects allowed bookmarks present in Word but omitted from RequiredBookmarks.
Clean template state
Turn off Track Changes, resolve revisions in every story, remove comments, and keep bookmark ranges free from nested objects.
Move the pack through six control gates
1. Approve the case
Review every A–I value and mark the one EvidenceCase row exactly READY.
2. Approve the document register
Validate unique keys, templates, output suffixes, bookmark contracts, optional image files, and APPROVED/RETIRED status.
3. Snapshot approved inputs
Copy every approved template and used evidence image into the run-specific InputSnapshot.
4. Recheck before each document
Stop if the EvidenceCase row or current DocumentRegister row changes after preflight.
5. Generate and stage
Fill only declared bookmarks, embed an image when required, create DOCX/PDF pairs, and move them into Completed.
6. Confirm the complete register
Recheck the entire case and register, confirm generatedCount equals approvedCount, then save DONE.
Free Excel VBA example: generate one compliance evidence pack
Save the workbook as .xlsm. Create EvidenceCase and DocumentRegister with the exact headers above. Put approved DOCX templates in Templates and optional PNG/JPG/JPEG files in Assets\EvidenceImages. Run GenerateComplianceEvidencePack.
Option Explicit
Private Const PACK_SHEET As String = "EvidenceCase"
Private Const REGISTER_SHEET As String = "DocumentRegister"
Private Const STATUS_READY As String = "READY"
Private Const STATUS_HOLD As String = "HOLD"
Private Const STATUS_DONE As String = "DONE"
Private Const DOC_APPROVED As String = "APPROVED"
Private Const DOC_RETIRED As String = "RETIRED"
Private Const WD_FORMAT_DOCX As Long = 12
Private Const WD_EXPORT_PDF As Long = 17
Private Const WD_ALERTS_NONE As Long = 0
Private Const WD_DO_NOT_SAVE_CHANGES As Long = 0
Private Const WD_COLLAPSE_START As Long = 1
Private Const OFFICE_TRUE As Long = -1
Private Const POINTS_PER_CM As Double = 28.3464567
Public Sub GenerateComplianceEvidencePack()
Dim wb As Workbook
Dim packWs As Worksheet
Dim registerWs As Worksheet
Dim fso As Object
Dim wdApp As Object
Dim doc As Object
Dim packData As Variant
Dim registerData As Variant
Dim templateSnapshots As Object
Dim evidenceImageSnapshots As Object
Dim documentKeys As Object
Dim templateFiles As Object
Dim outputSuffixes As Object
Dim requiredBookmarks As Object
Dim packId As String
Dim controlId As String
Dim organizationName As String
Dim reviewPeriodDisplay As String
Dim frameworkName As String
Dim controlOwner As String
Dim controlNarrative As String
Dim reviewerName As String
Dim packStatus As String
Dim documentKey As String
Dim templateFile As String
Dim outputSuffix As String
Dim bookmarkContract As String
Dim evidenceImageFile As String
Dim documentStatus As String
Dim templateFolder As String
Dim evidenceImageFolder As String
Dim outputRoot As String
Dim runFolder As String
Dim inputFolder As String
Dim templateSnapshotFolder As String
Dim evidenceImageSnapshotFolder As String
Dim stagingFolder As String
Dim completedFolder As String
Dim sourcePath As String
Dim snapshotPath As String
Dim tempDocxPath As String
Dim tempPdfPath As String
Dim finalDocxPath As String
Dim finalPdfPath As String
Dim outputStem As String
Dim lastRegisterRow As Long
Dim dataRow As Long
Dim excelRow As Long
Dim approvedCount As Long
Dim generatedCount As Long
Dim previousScreenUpdating As Boolean
Dim previousEnableEvents As Boolean
Dim stateCaptured As Boolean
Dim currentStep As String
Dim errorNumber As Long
Dim errorDescription As String
Dim finalStatusPending As Boolean
Dim statusRecoveryMessage As String
On Error GoTo CleanFail
Set wb = ThisWorkbook
previousScreenUpdating = Application.ScreenUpdating
previousEnableEvents = Application.EnableEvents
stateCaptured = True
Application.ScreenUpdating = False
Application.EnableEvents = False
currentStep = "checking the macro-enabled workbook"
RequireWritableMacroWorkbook wb
Set packWs = RequireWorksheet(wb, PACK_SHEET)
Set registerWs = RequireWorksheet(wb, REGISTER_SHEET)
If packWs.ProtectContents Or registerWs.ProtectContents Then
Err.Raise vbObjectError + 5100, , _
"EvidenceCase and DocumentRegister must allow status updates."
End If
ValidatePackHeaders packWs
ValidateRegisterHeaders registerWs
RequireOnePackRow packWs
packData = packWs.Range("A2:I2").Value2
packId = ReadRequiredText(packData(1, 1), "PackID", 2)
controlId = ReadRequiredText(packData(1, 2), "ControlID", 2)
organizationName = ReadRequiredText(packData(1, 3), "OrganizationName", 2)
reviewPeriodDisplay = ReadRequiredText(packData(1, 4), "ReviewPeriodDisplay", 2)
frameworkName = ReadRequiredText( _
packData(1, 5), "FrameworkName", 2)
controlOwner = ReadOptionalText(packData(1, 6), "ControlOwner", 2)
controlNarrative = ReadRequiredMultilineText( _
packData(1, 7), "ControlNarrative", 2)
reviewerName = ReadRequiredText(packData(1, 8), "ReviewerName", 2)
packStatus = ReadRequiredText(packData(1, 9), "PackStatus", 2)
ValidatePackStatus packStatus
If packStatus <> STATUS_READY Then
Err.Raise vbObjectError + 5101, , _
"EvidenceCase row 2 must be exactly READY for generation."
End If
ValidateFileComponent packId, "PackID", 2
templateFolder = JoinPath(wb.Path, "Templates")
evidenceImageFolder = JoinPath(JoinPath(wb.Path, "Assets"), "EvidenceImages")
outputRoot = JoinPath(wb.Path, "GeneratedComplianceEvidencePacks")
RequireFolder templateFolder, "template folder"
lastRegisterRow = FindLastDataRow(registerWs, 6)
If lastRegisterRow < 2 Then
Err.Raise vbObjectError + 5102, , _
"DocumentRegister has no document rows."
End If
registerData = registerWs.Range("A2:F" & lastRegisterRow).Value2
Set documentKeys = NewTextDictionary(vbTextCompare)
Set templateFiles = NewTextDictionary(vbTextCompare)
Set outputSuffixes = NewTextDictionary(vbTextCompare)
currentStep = "preflighting the document register"
For dataRow = 1 To UBound(registerData, 1)
excelRow = dataRow + 1
If Not DataRowIsBlank(registerData, dataRow, 6) Then
documentStatus = ReadRequiredText( _
registerData(dataRow, 6), "DocumentStatus", excelRow)
ValidateDocumentStatus documentStatus, excelRow
If documentStatus = DOC_APPROVED Then
documentKey = ReadRequiredText( _
registerData(dataRow, 1), "DocumentKey", excelRow)
templateFile = ReadRequiredText( _
registerData(dataRow, 2), "TemplateFile", excelRow)
outputSuffix = ReadRequiredText( _
registerData(dataRow, 3), "OutputSuffix", excelRow)
bookmarkContract = ReadRequiredText( _
registerData(dataRow, 4), "RequiredBookmarks", excelRow)
evidenceImageFile = ReadOptionalText( _
registerData(dataRow, 5), "EvidenceImageFile", excelRow)
ValidateKey documentKey, "DocumentKey", excelRow
ValidateDocxFileName templateFile, excelRow
ValidateFileComponent outputSuffix, "OutputSuffix", excelRow
AddUnique documentKeys, documentKey, "DocumentKey", excelRow
AddUnique templateFiles, templateFile, "TemplateFile", excelRow
AddUnique outputSuffixes, outputSuffix, "OutputSuffix", excelRow
Set requiredBookmarks = ParseBookmarkContract( _
bookmarkContract, excelRow)
If requiredBookmarks.Exists("ControlOwner") And _
Len(controlOwner) = 0 Then
Err.Raise vbObjectError + 5159, , _
"ControlOwner is required by the template contract " & _
"on DocumentRegister row " & excelRow & "."
End If
ValidateEvidenceImageContract requiredBookmarks, evidenceImageFile, excelRow
sourcePath = JoinPath(templateFolder, templateFile)
RequireNonemptyFile sourcePath, _
"template on DocumentRegister row " & excelRow
If Len(evidenceImageFile) > 0 Then
ValidateImageFileName evidenceImageFile, excelRow
sourcePath = JoinPath(evidenceImageFolder, evidenceImageFile)
RequireNonemptyFile sourcePath, _
"evidence image on DocumentRegister row " & excelRow
End If
approvedCount = approvedCount + 1
End If
End If
Next dataRow
If approvedCount = 0 Then
Err.Raise vbObjectError + 5103, , _
"DocumentRegister has no rows marked exactly APPROVED."
End If
currentStep = "saving the preflighted workbook"
wb.Save
Set fso = CreateObject("Scripting.FileSystemObject")
EnsureFolder outputRoot
runFolder = CreateRunFolder(fso, outputRoot, packId)
inputFolder = JoinPath(runFolder, "InputSnapshot")
templateSnapshotFolder = JoinPath(inputFolder, "Templates")
evidenceImageSnapshotFolder = JoinPath(inputFolder, "EvidenceImages")
stagingFolder = JoinPath(runFolder, "Staging")
completedFolder = JoinPath(runFolder, "Completed")
fso.CreateFolder inputFolder
fso.CreateFolder templateSnapshotFolder
fso.CreateFolder evidenceImageSnapshotFolder
fso.CreateFolder stagingFolder
fso.CreateFolder completedFolder
Set templateSnapshots = NewTextDictionary(vbTextCompare)
Set evidenceImageSnapshots = NewTextDictionary(vbTextCompare)
currentStep = "creating the controlled input snapshot"
For dataRow = 1 To UBound(registerData, 1)
If CStr(registerData(dataRow, 6)) = DOC_APPROVED Then
templateFile = CStr(registerData(dataRow, 2))
sourcePath = JoinPath(templateFolder, templateFile)
snapshotPath = JoinPath(templateSnapshotFolder, templateFile)
CopyFileToSnapshot fso, sourcePath, snapshotPath, _
"template " & templateFile
templateSnapshots.Add templateFile, snapshotPath
evidenceImageFile = CStr(registerData(dataRow, 5))
If Len(evidenceImageFile) > 0 And _
Not evidenceImageSnapshots.Exists(evidenceImageFile) Then
sourcePath = JoinPath(evidenceImageFolder, evidenceImageFile)
snapshotPath = JoinPath(evidenceImageSnapshotFolder, evidenceImageFile)
CopyFileToSnapshot fso, sourcePath, snapshotPath, _
"evidence image " & evidenceImageFile
evidenceImageSnapshots.Add evidenceImageFile, snapshotPath
End If
End If
Next dataRow
currentStep = "starting Microsoft Word Desktop"
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = False
wdApp.DisplayAlerts = WD_ALERTS_NONE
wdApp.ScreenUpdating = False
For dataRow = 1 To UBound(registerData, 1)
excelRow = dataRow + 1
If CStr(registerData(dataRow, 6)) = DOC_APPROVED Then
currentStep = "rechecking the compliance evidence pack and register row " & excelRow
RequireRangeUnchanged packWs.Range("A2:I2"), packData, 1, 9, _
"EvidenceCase row 2"
RequireRangeUnchanged registerWs.Range("A" & excelRow & _
":F" & excelRow), registerData, dataRow, 6, _
"DocumentRegister row " & excelRow
documentKey = CStr(registerData(dataRow, 1))
templateFile = CStr(registerData(dataRow, 2))
outputSuffix = CStr(registerData(dataRow, 3))
bookmarkContract = CStr(registerData(dataRow, 4))
evidenceImageFile = CStr(registerData(dataRow, 5))
Set requiredBookmarks = ParseBookmarkContract( _
bookmarkContract, excelRow)
outputStem = packId & "_" & outputSuffix
ValidateFileComponent outputStem, "combined output name", excelRow
tempDocxPath = JoinPath(stagingFolder, outputStem & ".docx")
tempPdfPath = JoinPath(stagingFolder, outputStem & ".pdf")
finalDocxPath = JoinPath(completedFolder, outputStem & ".docx")
finalPdfPath = JoinPath(completedFolder, outputStem & ".pdf")
RequireTargetAbsent tempDocxPath
RequireTargetAbsent tempPdfPath
RequireTargetAbsent finalDocxPath
RequireTargetAbsent finalPdfPath
currentStep = "generating " & documentKey
Set doc = wdApp.Documents.Open( _
templateSnapshots(templateFile), False, True, False)
ValidateTemplate doc, requiredBookmarks, templateFile
PopulateRequiredBookmarks doc, requiredBookmarks, _
packId, controlId, organizationName, reviewPeriodDisplay, _
frameworkName, controlOwner, controlNarrative, _
reviewerName, evidenceImageFile, evidenceImageSnapshots
ValidateResultBeforeSave doc, requiredBookmarks, documentKey
doc.SaveAs2 tempDocxPath, WD_FORMAT_DOCX
doc.ExportAsFixedFormat tempPdfPath, WD_EXPORT_PDF, False, 0, _
0, 1, 1, 0, True, True, 0, True, True, False
doc.Close WD_DO_NOT_SAVE_CHANGES
Set doc = Nothing
RequireNonemptyFile tempDocxPath, "staged DOCX " & documentKey
RequireNonemptyFile tempPdfPath, "staged PDF " & documentKey
Name tempDocxPath As finalDocxPath
Name tempPdfPath As finalPdfPath
generatedCount = generatedCount + 1
End If
Next dataRow
currentStep = "confirming the complete pack and document register"
If FindLastDataRow(packWs, 9) <> 2 Then
Err.Raise vbObjectError + 5160, , _
"EvidenceCase row count changed after preflight."
End If
If FindLastDataRow(registerWs, 6) <> lastRegisterRow Then
Err.Raise vbObjectError + 5161, , _
"DocumentRegister row count changed after preflight."
End If
RequireTableUnchanged packWs.Range("A2:I2"), packData, 1, 9, _
"EvidenceCase"
RequireTableUnchanged registerWs.Range("A2:F" & lastRegisterRow), _
registerData, UBound(registerData, 1), 6, "DocumentRegister"
If generatedCount <> approvedCount Then
Err.Raise vbObjectError + 5162, , _
"Generated document count does not match the approved count."
End If
currentStep = "saving the generated status to EvidenceCase"
finalStatusPending = True
packWs.Cells(2, 9).Value2 = STATUS_DONE
wb.Save
finalStatusPending = False
wdApp.NormalTemplate.Saved = True
wdApp.Quit WD_DO_NOT_SAVE_CHANGES
Set wdApp = Nothing
RestoreExcelState previousScreenUpdating, previousEnableEvents
stateCaptured = False
MsgBox "Compliance evidence pack completed." & vbCrLf & _
"Documents generated: " & generatedCount & vbCrLf & _
"Completed folder: " & completedFolder & vbCrLf & vbCrLf & _
"Review organization, control narrative, evidence images, DOCX, and PDF before release.", _
vbInformation
CleanExit:
On Error Resume Next
If Not doc Is Nothing Then doc.Close WD_DO_NOT_SAVE_CHANGES
If Not wdApp Is Nothing Then
wdApp.NormalTemplate.Saved = True
wdApp.Quit WD_DO_NOT_SAVE_CHANGES
End If
If stateCaptured Then _
RestoreExcelState previousScreenUpdating, previousEnableEvents
On Error GoTo 0
Exit Sub
CleanFail:
errorNumber = Err.Number
errorDescription = Err.Description
On Error Resume Next
If finalStatusPending And Not packWs Is Nothing Then
packWs.Cells(2, 9).Value2 = packStatus
statusRecoveryMessage = vbCrLf & _
"DONE was restored to " & packStatus & _
" in memory because the final workbook save was not confirmed."
End If
If Not doc Is Nothing Then doc.Close WD_DO_NOT_SAVE_CHANGES
If Not wdApp Is Nothing Then
wdApp.NormalTemplate.Saved = True
wdApp.Quit WD_DO_NOT_SAVE_CHANGES
End If
If stateCaptured Then _
RestoreExcelState previousScreenUpdating, previousEnableEvents
On Error GoTo 0
MsgBox "Compliance evidence pack generation stopped while " & currentStep & "." & _
vbCrLf & "Error " & errorNumber & ": " & errorDescription & _
vbCrLf & IIf(Len(runFolder) > 0, _
"Inspect the retained run folder: " & runFolder, _
"No run folder was created.") & vbCrLf & _
"Existing completed files were not deleted." & _
statusRecoveryMessage, vbCritical
End Sub
Private Sub PopulateRequiredBookmarks(ByVal doc As Object, _
ByVal required As Object, _
ByVal packId As String, _
ByVal controlId As String, _
ByVal organizationName As String, _
ByVal reviewPeriodDisplay As String, _
ByVal frameworkName As String, _
ByVal controlOwner As String, _
ByVal controlNarrative As String, _
ByVal reviewerName As String, _
ByVal evidenceImageFile As String, _
ByVal evidenceImages As Object)
Dim token As Variant
For Each token In required.Keys
Select Case CStr(token)
Case "PackID": WriteTextBookmark doc, CStr(token), packId
Case "ControlID": WriteTextBookmark doc, CStr(token), controlId
Case "OrganizationName": WriteTextBookmark doc, CStr(token), organizationName
Case "ReviewPeriodDisplay": WriteTextBookmark doc, CStr(token), reviewPeriodDisplay
Case "FrameworkName"
WriteTextBookmark doc, CStr(token), frameworkName
Case "ControlOwner": WriteTextBookmark doc, CStr(token), controlOwner
Case "ControlNarrative": WriteTextBookmark doc, CStr(token), controlNarrative
Case "ReviewerName"
WriteTextBookmark doc, CStr(token), reviewerName
Case "EvidenceImage"
InsertEvidenceImageBookmark doc, CStr(token), _
evidenceImages(evidenceImageFile)
End Select
Next token
End Sub
Private Sub ValidateTemplate(ByVal doc As Object, _
ByVal required As Object, _
ByVal templateFile As String)
RejectTrackedChanges doc, "template " & templateFile
If doc.Comments.Count > 0 Then
Err.Raise vbObjectError + 5104, , _
"Remove comments from template " & templateFile & "."
End If
ValidateBookmarkContract doc, required, templateFile
End Sub
Private Sub ValidateResultBeforeSave(ByVal doc As Object, _
ByVal required As Object, _
ByVal documentKey As String)
RejectTrackedChanges doc, "generated document " & documentKey
If doc.Comments.Count > 0 Then
Err.Raise vbObjectError + 5105, , _
"Generated document contains comments: " & documentKey
End If
ValidateBookmarkContract doc, required, documentKey
End Sub
Private Sub ValidateBookmarkContract(ByVal doc As Object, _
ByVal required As Object, _
ByVal documentLabel As String)
Dim token As Variant
Dim allowed As Object
Set allowed = AllowedBookmarkNames()
For Each token In required.Keys
If Not doc.Bookmarks.Exists(CStr(token)) Then
Err.Raise vbObjectError + 5106, , _
"Missing bookmark " & token & " in " & documentLabel & "."
End If
Next token
For Each token In allowed.Keys
If doc.Bookmarks.Exists(CStr(token)) And _
Not required.Exists(CStr(token)) Then
Err.Raise vbObjectError + 5107, , _
"Bookmark " & token & " exists but is not listed in " & _
"RequiredBookmarks for " & documentLabel & "."
End If
Next token
End Sub
Private Function ParseBookmarkContract(ByVal contractText As String, _
ByVal excelRow As Long) As Object
Dim result As Object
Dim allowed As Object
Dim tokens As Variant
Dim token As Variant
Dim tokenText As String
Set result = NewTextDictionary(vbBinaryCompare)
Set allowed = AllowedBookmarkNames()
tokens = Split(contractText, ";")
For Each token In tokens
tokenText = CStr(token)
If Len(tokenText) = 0 Or tokenText <> Trim$(tokenText) Then
Err.Raise vbObjectError + 5108, , _
"RequiredBookmarks has an empty or padded token on row " & _
excelRow & "."
End If
If Not allowed.Exists(tokenText) Then
Err.Raise vbObjectError + 5109, , _
"Unknown or incorrectly cased bookmark on row " & excelRow & _
": " & tokenText
End If
If result.Exists(tokenText) Then
Err.Raise vbObjectError + 5110, , _
"Duplicate bookmark token on row " & excelRow & ": " & tokenText
End If
result.Add tokenText, True
Next token
If Not result.Exists("PackID") Or _
Not result.Exists("ControlID") Or _
Not result.Exists("OrganizationName") Then
Err.Raise vbObjectError + 5111, , _
"Every approved template must require PackID, ControlID, " & _
"and OrganizationName."
End If
Set ParseBookmarkContract = result
End Function
Private Function AllowedBookmarkNames() As Object
Dim result As Object
Dim item As Variant
Set result = NewTextDictionary(vbBinaryCompare)
For Each item In Array("PackID", "ControlID", "OrganizationName", _
"ReviewPeriodDisplay", "FrameworkName", "ControlOwner", _
"ControlNarrative", "ReviewerName", "EvidenceImage")
result.Add CStr(item), True
Next item
Set AllowedBookmarkNames = result
End Function
Private Sub ValidateEvidenceImageContract(ByVal required As Object, _
ByVal evidenceImageFile As String, _
ByVal excelRow As Long)
If required.Exists("EvidenceImage") And Len(evidenceImageFile) = 0 Then
Err.Raise vbObjectError + 5112, , _
"EvidenceImageFile is required when EvidenceImage is listed on row " & _
excelRow & "."
End If
If Not required.Exists("EvidenceImage") And Len(evidenceImageFile) > 0 Then
Err.Raise vbObjectError + 5113, , _
"EvidenceImageFile must be blank when EvidenceImage is not listed " & _
"on row " & excelRow & "."
End If
End Sub
Private Sub WriteTextBookmark(ByVal doc As Object, _
ByVal bookmarkName As String, _
ByVal replacementText As String)
Dim targetRange As Object
Dim styleValue As Variant
Set targetRange = doc.Bookmarks(bookmarkName).Range
If targetRange.Fields.Count > 0 Or _
targetRange.ContentControls.Count > 0 Or _
targetRange.InlineShapes.Count > 0 Then
Err.Raise vbObjectError + 5114, , _
"Text bookmark contains a nested object: " & bookmarkName
End If
RejectRangeMarkers targetRange, bookmarkName
styleValue = targetRange.Style
targetRange.Text = replacementText
targetRange.Style = styleValue
doc.Bookmarks.Add bookmarkName, targetRange
If Not doc.Bookmarks.Exists(bookmarkName) Then
Err.Raise vbObjectError + 5115, , _
"Bookmark was not restored: " & bookmarkName
End If
If StrComp(doc.Bookmarks(bookmarkName).Range.Text, replacementText, _
vbBinaryCompare) <> 0 Then
Err.Raise vbObjectError + 5116, , _
"Bookmark value differs after replacement: " & bookmarkName
End If
End Sub
Private Sub InsertEvidenceImageBookmark(ByVal doc As Object, _
ByVal bookmarkName As String, _
ByVal imagePath As String)
Dim targetRange As Object
Dim picture As Object
Set targetRange = doc.Bookmarks(bookmarkName).Range
If targetRange.Fields.Count > 0 Or _
targetRange.ContentControls.Count > 0 Or _
targetRange.InlineShapes.Count > 0 Then
Err.Raise vbObjectError + 5117, , _
"Evidence image bookmark contains a nested object."
End If
RejectRangeMarkers targetRange, bookmarkName
targetRange.Text = ""
targetRange.Collapse WD_COLLAPSE_START
Set picture = doc.InlineShapes.AddPicture( _
imagePath, False, True, targetRange)
If picture.Width <= 0 Or picture.Height <= 0 Then
Err.Raise vbObjectError + 5118, , _
"Word inserted an invalid evidence image."
End If
picture.LockAspectRatio = OFFICE_TRUE
If picture.Width > 15# * POINTS_PER_CM Then _
picture.Width = 15# * POINTS_PER_CM
If picture.Height > 10# * POINTS_PER_CM Then _
picture.Height = 10# * POINTS_PER_CM
doc.Bookmarks.Add bookmarkName, picture.Range
If doc.Bookmarks(bookmarkName).Range.InlineShapes.Count <> 1 Then
Err.Raise vbObjectError + 5119, , _
"Evidence image bookmark does not contain one embedded image."
End If
End Sub
Private Sub RejectRangeMarkers(ByVal targetRange As Object, _
ByVal bookmarkName As String)
If InStr(1, targetRange.Text, vbCr, vbBinaryCompare) > 0 Or _
InStr(1, targetRange.Text, Chr$(7), vbBinaryCompare) > 0 Then
Err.Raise vbObjectError + 5120, , _
"Bookmark includes a paragraph or cell marker: " & bookmarkName
End If
End Sub
Private Sub RejectTrackedChanges(ByVal doc As Object, _
ByVal documentLabel As String)
If doc.TrackRevisions Then
Err.Raise vbObjectError + 5121, , _
"Turn off Track Changes in " & documentLabel & "."
End If
If CountRevisionsInAllStories(doc) > 0 Then
Err.Raise vbObjectError + 5122, , _
"Resolve tracked revisions in every story of " & _
documentLabel & "."
End If
End Sub
Private Function CountRevisionsInAllStories(ByVal doc As Object) As Long
Dim root As Object
Dim story As Object
Dim total As Long
For Each root In doc.StoryRanges
Set story = root
Do While Not story Is Nothing
total = total + story.Revisions.Count
Set story = story.NextStoryRange
Loop
Next root
CountRevisionsInAllStories = total
End Function
Private Sub ValidatePackHeaders(ByVal ws As Worksheet)
ValidateHeaders ws, Array("PackID", "ControlID", "OrganizationName", _
"ReviewPeriodDisplay", "FrameworkName", "ControlOwner", _
"ControlNarrative", "ReviewerName", "PackStatus")
End Sub
Private Sub ValidateRegisterHeaders(ByVal ws As Worksheet)
ValidateHeaders ws, Array("DocumentKey", "TemplateFile", _
"OutputSuffix", "RequiredBookmarks", "EvidenceImageFile", _
"DocumentStatus")
End Sub
Private Sub ValidateHeaders(ByVal ws As Worksheet, ByVal expected As Variant)
Dim columnIndex As Long
Dim valueText As Variant
For columnIndex = 1 To UBound(expected) + 1
valueText = ws.Cells(1, columnIndex).Value2
If IsError(valueText) Or VarType(valueText) <> vbString Then
Err.Raise vbObjectError + 5123, , _
"Header " & ws.Cells(1, columnIndex).Address(False, False) & _
" on " & ws.Name & " must contain exact text."
End If
If StrComp(CStr(valueText), CStr(expected(columnIndex - 1)), _
vbBinaryCompare) <> 0 Then
Err.Raise vbObjectError + 5124, , _
"Expected header " & expected(columnIndex - 1) & _
" in column " & columnIndex & " on " & ws.Name & "."
End If
Next columnIndex
End Sub
Private Sub RequireOnePackRow(ByVal ws As Worksheet)
Dim lastRow As Long
lastRow = FindLastDataRow(ws, 9)
If lastRow < 2 Then
Err.Raise vbObjectError + 5125, , _
"EvidenceCase row 2 is missing."
End If
If lastRow > 2 Then
Err.Raise vbObjectError + 5126, , _
"Contractor logic accepts one reviewed EvidenceCase row per run."
End If
End Sub
Private Function FindLastDataRow(ByVal ws As Worksheet, _
ByVal lastColumn As Long) As Long
Dim lastCell As Range
Set lastCell = ws.Range(ws.Cells(1, 1), _
ws.Cells(ws.Rows.Count, lastColumn)).Find( _
What:="*", After:=ws.Cells(1, 1), LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, MatchCase:=False)
If lastCell Is Nothing Then
FindLastDataRow = 0
Else
FindLastDataRow = lastCell.Row
End If
End Function
Private Function DataRowIsBlank(ByRef data As Variant, _
ByVal dataRow As Long, _
ByVal columnCount As Long) As Boolean
Dim columnIndex As Long
DataRowIsBlank = True
For columnIndex = 1 To columnCount
If IsError(data(dataRow, columnIndex)) Then
DataRowIsBlank = False
Exit Function
End If
If Len(CStr(data(dataRow, columnIndex))) > 0 Then
DataRowIsBlank = False
Exit Function
End If
Next columnIndex
End Function
Private Function ReadRequiredText(ByVal rawValue As Variant, _
ByVal fieldName As String, _
ByVal excelRow As Long) As String
ReadRequiredText = ReadOptionalText(rawValue, fieldName, excelRow)
If Len(ReadRequiredText) = 0 Then
Err.Raise vbObjectError + 5127, , _
fieldName & " is required on row " & excelRow & "."
End If
End Function
Private Function ReadOptionalText(ByVal rawValue As Variant, _
ByVal fieldName As String, _
ByVal excelRow As Long) As String
If IsEmpty(rawValue) Then
ReadOptionalText = ""
Exit Function
End If
If IsError(rawValue) Or VarType(rawValue) <> vbString Then
Err.Raise vbObjectError + 5128, , _
fieldName & " must be stored as text on row " & excelRow & "."
End If
ReadOptionalText = CStr(rawValue)
If ReadOptionalText <> Trim$(ReadOptionalText) Then
Err.Raise vbObjectError + 5129, , _
fieldName & " has outer whitespace on row " & excelRow & "."
End If
If ContainsControlCharacter(ReadOptionalText) Then
Err.Raise vbObjectError + 5130, , _
fieldName & " contains a control character on row " & excelRow & "."
End If
End Function
Private Function ReadRequiredMultilineText(ByVal rawValue As Variant, _
ByVal fieldName As String, _
ByVal excelRow As Long) As String
Dim valueText As String
Dim index As Long
Dim code As Long
If IsEmpty(rawValue) Then
Err.Raise vbObjectError + 5168, , _
fieldName & " is required on row " & excelRow & "."
End If
If IsError(rawValue) Or VarType(rawValue) <> vbString Then
Err.Raise vbObjectError + 5169, , _
fieldName & " must be stored as text on row " & excelRow & "."
End If
valueText = CStr(rawValue)
valueText = Replace(valueText, vbCrLf, vbLf)
valueText = Replace(valueText, vbCr, vbLf)
If Len(valueText) = 0 Then
Err.Raise vbObjectError + 5170, , _
fieldName & " is required on row " & excelRow & "."
End If
If valueText <> Trim$(valueText) Or _
Left$(valueText, 1) = vbLf Or Right$(valueText, 1) = vbLf Then
Err.Raise vbObjectError + 5171, , _
fieldName & " has outer whitespace on row " & excelRow & "."
End If
For index = 1 To Len(valueText)
code = AscW(Mid$(valueText, index, 1))
If code >= 0 And code <= 31 And code <> 10 Then
Err.Raise vbObjectError + 5172, , _
fieldName & " contains an unsupported control character on row " & _
excelRow & "."
End If
Next index
ReadRequiredMultilineText = Replace(valueText, vbLf, vbCr)
End Function
Private Sub ValidatePackStatus(ByVal statusText As String)
If statusText <> STATUS_READY And statusText <> STATUS_HOLD And _
statusText <> STATUS_DONE Then
Err.Raise vbObjectError + 5131, , _
"PackStatus must be exactly READY, HOLD, or DONE."
End If
End Sub
Private Sub ValidateDocumentStatus(ByVal statusText As String, _
ByVal excelRow As Long)
If statusText <> DOC_APPROVED And statusText <> DOC_RETIRED Then
Err.Raise vbObjectError + 5132, , _
"DocumentStatus must be exactly APPROVED or RETIRED on row " & _
excelRow & "."
End If
End Sub
Private Sub ValidateKey(ByVal valueText As String, _
ByVal fieldName As String, _
ByVal excelRow As Long)
If Len(valueText) > 80 Then
Err.Raise vbObjectError + 5133, , _
fieldName & " exceeds 80 characters on row " & excelRow & "."
End If
End Sub
Private Sub ValidateFileComponent(ByVal valueText As String, _
ByVal fieldName As String, _
ByVal excelRow As Long)
Dim item As Variant
Dim baseName As String
Dim lowerName As String
If Len(valueText) > 100 Then
Err.Raise vbObjectError + 5134, , _
fieldName & " exceeds 100 characters on row " & excelRow & "."
End If
For Each item In Array("<", ">", ":", Chr$(34), "/", "\", _
"|", "?", "*")
If InStr(1, valueText, CStr(item), vbBinaryCompare) > 0 Then
Err.Raise vbObjectError + 5135, , _
fieldName & " contains a forbidden Windows character on row " & _
excelRow & "."
End If
Next item
If Right$(valueText, 1) = "." Or Right$(valueText, 1) = " " Then
Err.Raise vbObjectError + 5136, , _
fieldName & " ends with a period or space on row " & excelRow & "."
End If
lowerName = LCase$(valueText)
If Right$(lowerName, 5) = ".docx" Or _
Right$(lowerName, 4) = ".pdf" Then
Err.Raise vbObjectError + 5137, , _
fieldName & " must not include .docx or .pdf on row " & excelRow & "."
End If
baseName = valueText
If InStr(1, baseName, ".", vbBinaryCompare) > 0 Then
baseName = Left$(baseName, InStr(1, baseName, ".", _
vbBinaryCompare) - 1)
End If
If IsReservedWindowsName(baseName) Then
Err.Raise vbObjectError + 5138, , _
fieldName & " uses a reserved Windows name on row " & excelRow & "."
End If
End Sub
Private Sub ValidateDocxFileName(ByVal fileName As String, _
ByVal excelRow As Long)
ValidateAssetFileName fileName, excelRow
If LCase$(Right$(fileName, 5)) <> ".docx" Then
Err.Raise vbObjectError + 5139, , _
"TemplateFile must end with .docx on row " & excelRow & "."
End If
End Sub
Private Sub ValidateImageFileName(ByVal fileName As String, _
ByVal excelRow As Long)
Dim lowerName As String
ValidateAssetFileName fileName, excelRow
lowerName = LCase$(fileName)
If Right$(lowerName, 4) <> ".png" And _
Right$(lowerName, 4) <> ".jpg" And _
Right$(lowerName, 5) <> ".jpeg" Then
Err.Raise vbObjectError + 5140, , _
"EvidenceImageFile must be PNG, JPG, or JPEG on row " & excelRow & "."
End If
End Sub
Private Sub ValidateAssetFileName(ByVal fileName As String, _
ByVal excelRow As Long)
Dim item As Variant
Dim dotPosition As Long
Dim baseName As String
If Len(fileName) > 120 Then
Err.Raise vbObjectError + 5165, , _
"Asset filename exceeds 120 characters on row " & excelRow & "."
End If
If ContainsControlCharacter(fileName) Then
Err.Raise vbObjectError + 5166, , _
"Asset filename contains a control character on row " & _
excelRow & "."
End If
For Each item In Array("<", ">", ":", Chr$(34), "/", "\", _
"|", "?", "*")
If InStr(1, fileName, CStr(item), vbBinaryCompare) > 0 Then
Err.Raise vbObjectError + 5141, , _
"Asset filename contains a path or wildcard on row " & _
excelRow & "."
End If
Next item
If Right$(fileName, 1) = "." Or Right$(fileName, 1) = " " Then
Err.Raise vbObjectError + 5142, , _
"Asset filename ends with a period or space on row " & excelRow & "."
End If
dotPosition = InStr(1, fileName, ".", vbBinaryCompare)
If dotPosition > 1 Then
baseName = Left$(fileName, dotPosition - 1)
Else
baseName = fileName
End If
If IsReservedWindowsName(baseName) Then
Err.Raise vbObjectError + 5167, , _
"Asset filename uses a reserved Windows name on row " & _
excelRow & "."
End If
End Sub
Private Sub AddUnique(ByVal values As Object, ByVal valueText As String, _
ByVal fieldName As String, ByVal excelRow As Long)
If values.Exists(valueText) Then
Err.Raise vbObjectError + 5143, , _
"Duplicate " & fieldName & " on rows " & values(valueText) & _
" and " & excelRow & ": " & valueText
End If
values.Add valueText, excelRow
End Sub
Private Function NewTextDictionary(ByVal compareMode As Long) As Object
Dim result As Object
Set result = CreateObject("Scripting.Dictionary")
result.CompareMode = compareMode
Set NewTextDictionary = result
End Function
Private Sub RequireRangeUnchanged(ByVal liveRange As Range, _
ByRef snapshot As Variant, _
ByVal snapshotRow As Long, _
ByVal columnCount As Long, _
ByVal rangeLabel As String)
Dim liveData As Variant
Dim columnIndex As Long
liveData = liveRange.Value2
For columnIndex = 1 To columnCount
If Not ValuesExactlyEqual(snapshot(snapshotRow, columnIndex), _
liveData(1, columnIndex)) Then
Err.Raise vbObjectError + 5144, , _
rangeLabel & " changed after preflight. Start a new run."
End If
Next columnIndex
End Sub
Private Sub RequireTableUnchanged(ByVal liveRange As Range, _
ByRef snapshot As Variant, _
ByVal expectedRows As Long, _
ByVal expectedColumns As Long, _
ByVal tableLabel As String)
Dim liveData As Variant
Dim rowIndex As Long
Dim columnIndex As Long
If liveRange.Rows.Count <> expectedRows Or _
liveRange.Columns.Count <> expectedColumns Then
Err.Raise vbObjectError + 5163, , _
tableLabel & " dimensions changed after preflight."
End If
liveData = liveRange.Value2
For rowIndex = 1 To expectedRows
For columnIndex = 1 To expectedColumns
If Not ValuesExactlyEqual(snapshot(rowIndex, columnIndex), _
liveData(rowIndex, columnIndex)) Then
Err.Raise vbObjectError + 5164, , _
tableLabel & " changed after preflight at row " & _
(rowIndex + 1) & ", column " & columnIndex & "."
End If
Next columnIndex
Next rowIndex
End Sub
Private Function ValuesExactlyEqual(ByVal firstValue As Variant, _
ByVal secondValue As Variant) As Boolean
If IsError(firstValue) Or IsError(secondValue) Then Exit Function
If VarType(firstValue) <> VarType(secondValue) Then Exit Function
ValuesExactlyEqual = (StrComp(CStr(firstValue), CStr(secondValue), _
vbBinaryCompare) = 0)
End Function
Private Sub CopyFileToSnapshot(ByVal fso As Object, _
ByVal sourcePath As String, _
ByVal snapshotPath As String, _
ByVal fileLabel As String)
Dim sourceSize As Variant
Dim sourceModified As Date
Dim failureText As String
RequireNonemptyFile sourcePath, fileLabel
RequireTargetAbsent snapshotPath
On Error GoTo CopyFailed
sourceSize = fso.GetFile(sourcePath).Size
sourceModified = fso.GetFile(sourcePath).DateLastModified
fso.CopyFile sourcePath, snapshotPath, False
RequireNonemptyFile snapshotPath, fileLabel & " snapshot"
If fso.GetFile(snapshotPath).Size <> sourceSize Then
Err.Raise vbObjectError + 5145, , _
"Snapshot size differs for " & fileLabel & "."
End If
If fso.GetFile(sourcePath).Size <> sourceSize Or _
fso.GetFile(sourcePath).DateLastModified <> sourceModified Then
Err.Raise vbObjectError + 5146, , _
"Source changed while snapshotting " & fileLabel & "."
End If
Exit Sub
CopyFailed:
failureText = Err.Description
Err.Raise vbObjectError + 5147, , _
"Could not snapshot " & fileLabel & ": " & failureText
End Sub
Private Function CreateRunFolder(ByVal fso As Object, _
ByVal outputRoot As String, _
ByVal packId As String) As String
Dim baseName As String
Dim candidate As String
Dim suffix As Long
baseName = "Run_" & packId & "_" & Format$(Now, "yyyymmdd_hhnnss")
candidate = JoinPath(outputRoot, baseName)
Do While fso.FolderExists(candidate)
suffix = suffix + 1
candidate = JoinPath(outputRoot, baseName & "_" & _
Format$(suffix, "000"))
Loop
fso.CreateFolder candidate
CreateRunFolder = candidate
End Function
Private Sub RequireWritableMacroWorkbook(ByVal wb As Workbook)
If Len(wb.Path) = 0 Or LCase$(Right$(wb.Name, 5)) <> ".xlsm" Then
Err.Raise vbObjectError + 5148, , _
"Save this workbook as an Excel Macro-Enabled Workbook (.xlsm)."
End If
If wb.ReadOnly Then
Err.Raise vbObjectError + 5149, , _
"The workbook is read-only; DONE cannot be saved."
End If
End Sub
Private Function RequireWorksheet(ByVal wb As Workbook, _
ByVal sheetName As String) As Worksheet
On Error GoTo MissingSheet
Set RequireWorksheet = wb.Worksheets(sheetName)
Exit Function
MissingSheet:
Err.Raise vbObjectError + 5150, , _
"Missing worksheet: " & sheetName
End Function
Private Sub EnsureFolder(ByVal folderPath As String)
If FolderExistsStrict(folderPath) Then Exit Sub
On Error GoTo CreateFailed
MkDir folderPath
Exit Sub
CreateFailed:
Err.Raise vbObjectError + 5151, , _
"Could not create folder: " & folderPath & ". " & Err.Description
End Sub
Private Sub RequireFolder(ByVal folderPath As String, _
ByVal folderLabel As String)
If Not FolderExistsStrict(folderPath) Then
Err.Raise vbObjectError + 5152, , _
"Missing " & folderLabel & ": " & folderPath
End If
End Sub
Private Sub RequireTargetAbsent(ByVal filePath As String)
If FileExistsStrict(filePath) Then
Err.Raise vbObjectError + 5153, , _
"Refusing to overwrite existing file: " & filePath
End If
End Sub
Private Sub RequireNonemptyFile(ByVal filePath As String, _
ByVal fileLabel As String)
If Not FileExistsStrict(filePath) Then
Err.Raise vbObjectError + 5154, , _
"Missing " & fileLabel & ": " & filePath
End If
On Error GoTo InspectFailed
If FileLen(filePath) <= 0 Then
Err.Raise vbObjectError + 5155, , _
"Empty " & fileLabel & ": " & filePath
End If
Exit Sub
InspectFailed:
Err.Raise vbObjectError + 5156, , _
"Could not inspect " & fileLabel & ": " & filePath & _
". " & Err.Description
End Sub
Private Function FileExistsStrict(ByVal filePath As String) As Boolean
On Error GoTo CheckFailed
FileExistsStrict = (Len(Dir$(filePath, _
vbNormal Or vbHidden Or vbSystem Or vbReadOnly)) > 0)
Exit Function
CheckFailed:
Err.Raise vbObjectError + 5157, , _
"Could not check file path: " & filePath & ". " & Err.Description
End Function
Private Function FolderExistsStrict(ByVal folderPath As String) As Boolean
Dim resultText As String
On Error GoTo CheckFailed
resultText = Dir$(folderPath, vbDirectory)
If Len(resultText) > 0 Then
FolderExistsStrict = _
((GetAttr(folderPath) And vbDirectory) = vbDirectory)
End If
Exit Function
CheckFailed:
Err.Raise vbObjectError + 5158, , _
"Could not check folder: " & folderPath & ". " & Err.Description
End Function
Private Function JoinPath(ByVal parentPath As String, _
ByVal childName As String) As String
If Right$(parentPath, 1) = "\" Then
JoinPath = parentPath & childName
Else
JoinPath = parentPath & "\" & childName
End If
End Function
Private Function ContainsControlCharacter(ByVal valueText As String) As Boolean
Dim index As Long
Dim code As Long
For index = 1 To Len(valueText)
code = AscW(Mid$(valueText, index, 1))
If code >= 0 And code <= 31 Then
ContainsControlCharacter = True
Exit Function
End If
Next index
End Function
Private Function IsReservedWindowsName(ByVal baseName As String) As Boolean
Dim upperName As String
Dim suffixText As String
Dim suffixCode As Long
upperName = UCase$(baseName)
Select Case upperName
Case "CON", "PRN", "AUX", "NUL", "CLOCK$"
IsReservedWindowsName = True
Exit Function
End Select
If Len(upperName) >= 4 Then
If Left$(upperName, 3) = "COM" Or Left$(upperName, 3) = "LPT" Then
suffixText = Mid$(upperName, 4)
If Len(suffixText) = 1 Then
suffixCode = AscW(suffixText)
If (suffixCode >= AscW("1") And suffixCode <= AscW("9")) Or _
suffixText = ChrW$(&HB9) Or suffixText = ChrW$(&HB2) Or _
suffixText = ChrW$(&HB3) Then
IsReservedWindowsName = True
End If
End If
End If
End If
End Function
Private Sub RestoreExcelState(ByVal screenUpdatingValue As Boolean, _
ByVal enableEventsValue As Boolean)
Application.EnableEvents = enableEventsValue
Application.ScreenUpdating = screenUpdatingValue
End SubThe example uses Word’s documented bookmark checks, embedded image insertion, DOCX saving, and PDF export.
Review the generated pack before submission
Pack identity
Match PackID, ControlID, organization, framework, and review period across every generated file.
Document completeness
Confirm every APPROVED register row produced one nonempty DOCX/PDF pair and no RETIRED row was generated.
Narrative accuracy
Check scope, operation, referenced evidence, exceptions, conclusion, dates, and reviewer attribution.
Evidence image
Confirm the image belongs to the control and period, is legible, and is not presented as proof beyond its real provenance.
Word and PDF layout
Inspect tables, wrapping, headings, page breaks, headers, footers, and every PDF page.
Submission record
Record the approver, released versions, destination, transfer method, timestamp, and retained originals separately.
Keep the example inside its evidence limits
No compliance decision
The macro does not interpret requirements, test controls, or determine compliance.
No evidence-sufficiency decision
Generated pages do not prove that evidence is complete, relevant, reliable, or accepted.
Images only
The optional asset feature embeds PNG, JPG, or JPEG files; it does not ingest arbitrary evidence artifacts.
No authenticity or chain of custody
Copying and embedding a file do not establish provenance, timestamps, integrity history, or authorization.
No atomic pack transaction
Individual DOCX/PDF moves and the final Excel status save remain separate operations after a failure.
No repository controls
Access, encryption, hashes, versioning, retention, legal hold, audit logs, and submission remain external controls.
Use Contractor for one reviewed multi-document evidence case
DocxForge Pro Contractor starts with one reviewed case and produces several different documents from different Word templates.
One EvidenceCase supplies shared pack data. DocumentRegister defines the different approved templates and outputs that belong to that case.




Frequently asked questions
Is this a Contractor workflow?
Yes. One reviewed EvidenceCase row drives several different approved documents from different Word templates, such as a cover sheet, control narrative, evidence-image sheet, and action summary.
Does the VBA create a complete evidence repository?
No. It generates controlled DOCX/PDF documents and can embed an approved PNG, JPG, or JPEG in a template. It does not ingest arbitrary evidence files, calculate hashes, enforce retention, or replace an evidence-management system.
Why does every template require PackID and ControlID?
Those identifiers keep every generated document tied to the same pack and reviewed control scope. OrganizationName is also mandatory in every approved template contract.
What does RequiredBookmarks control?
It is a case-sensitive, semicolon-separated contract for each template. The macro rejects unknown, duplicate, padded, missing, or undeclared allowed bookmarks before saving the document.
Does DONE mean the evidence passed an audit?
No. DONE confirms that all APPROVED register rows were generated and the final workbook save succeeded. It does not mean evidence was sufficient, a control was effective, or an auditor accepted the pack.
Can an evidence image prove authenticity or chain of custody?
No. The macro checks the filename, extension, file presence, nonzero size, controlled copying, and Word insertion. Authenticity, provenance, timestamps, access history, and chain of custody require separate controls.