Alright, let's figure out how to embed VBA macros into a DOCX on Ubuntu since Windows-only tools like win32com won't cut it here. I've got two solid approaches for you, but the LibreOffice UNO method is the most reliable and straightforward for Linux environments.

Recommended Approach: Use LibreOffice UNO API via Python #

LibreOffice has a headless mode and a Python UNO binding that lets us automate document operations—including adding macros—without a GUI. Here's how to set it up:

Step 1: Install Dependencies #

First, make sure you have LibreOffice and its Python bindings installed:

sudo apt update && sudo apt install libreoffice libreoffice-python-uno

Step 2: Full Python Script (InsertMacro.py) #

This script handles command-line arguments, connects to LibreOffice (starts it if needed), injects your macro code, and saves the modified document.

import argparse
import uno
import unohelper
import os
import sys
import subprocess
import time

def add_macro_to_docx(input_docx, macro_path, output_docx):
    # Connect to LibreOffice UNO context
    local_context = uno.getComponentContext()
    resolver = local_context.ServiceManager.createInstanceWithContext(
        "com.sun.star.bridge.UnoUrlResolver", local_context)
    
    # Try to connect to running instance; start one if needed
    try:
        ctx = resolver.resolve("uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext")
    except Exception as e:
        print("Starting headless LibreOffice instance...")
        subprocess.Popen([
            "libreoffice",
            "--headless",
            "--invisible",
            "--nologo",
            "--accept=socket,host=localhost,port=2002;urp;"
        ])
        # Wait a few seconds for LibreOffice to initialize
        time.sleep(5)
        ctx = resolver.resolve("uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext")
    
    smgr = ctx.ServiceManager
    desktop = smgr.createInstanceWithContext("com.sun.star.frame.Desktop", ctx)

    # Open the input DOCX
    input_url = unohelper.systemPathToFileUrl(os.path.abspath(input_docx))
    doc = desktop.loadComponentFromURL(input_url, "_blank", 0, ())

    # Access the Basic libraries (where macros are stored)
    standard_lib = doc.BasicLibraries.getByName("Standard")
    module_name = "AutoOpenModule"

    # Remove existing module if it exists to avoid conflicts
    if standard_lib.hasByName(module_name):
        standard_lib.removeByName(module_name)
    
    # Create a new module for our macro
    macro_module = standard_lib.insertNewByName(module_name)

    # Read macro code from the text file
    with open(macro_path, 'r') as f:
        macro_code = f.read()

    # Inject the macro code into the module
    macro_module.setSourceCode(macro_code)

    # Save the modified document to the output path
    output_url = unohelper.systemPathToFileUrl(os.path.abspath(output_docx))
    doc.storeAsURL(output_url, ())
    doc.dispose()

if __name__ == "__main__":
    parser = argparse.ArgumentParser(description='Embed VBA macro into DOCX on Ubuntu')
    parser.add_argument('-f', '--file', required=True, help='Path to input DOCX file')
    parser.add_argument('-m', '--macro', required=True, help='Path to macro text file')
    parser.add_argument('-o', '--output', required=True, help='Path to output DOCX file')
    args = parser.parse_args()

    try:
        add_macro_to_docx(args.file, args.macro, args.output)
        print(f"✅ Macro embedded successfully! Output saved to: {args.output}")
    except Exception as e:
        print(f"❌ Error occurred: {str(e)}", file=sys.stderr)
        sys.exit(1)

Step 3: Run the Script #

Use the exact command format you specified:

python3 InsertMacro.py -f mydoc.docx -m macro.txt -o mydoc_macro.docx

Notes on This Approach #

• When you open the output DOCX in Microsoft Word, it will likely show a macro security warning—this is normal, as Office blocks macros by default for safety.
• If the port 2002 is already in use, change it in both the script's connection string and the LibreOffice startup command.
• Make sure your system's Python version matches the one used by LibreOffice (Ubuntu's default Python 3 should work out of the box).

Advanced Approach: Manually Modify the DOCX ZIP Structure #

DOCX files are just ZIP archives, and macros are stored in word/vbaProject.bin. This method requires manipulating the ZIP and generating a valid vbaProject.bin file with your macro code:

Key Steps #

1. Extract the Input DOCX: Use Python's built-in zipfile module to extract all files from the input DOCX.
2. Generate vbaProject.bin: This is an OLE compound document containing your VBA code. You can use tools like oletools to create this, but it's more complex than the LibreOffice method.
3. Modify Archive Files:
   • Add <Default Extension="bin" ContentType="application/vnd.ms-office.vbaProject"/> to [Content_Types].xml.
   • Add a relationship entry to word/_rels/document.xml.rels pointing to vbaProject.bin.
4. Repackage the ZIP: Recompress all files into a new DOCX.

This method is more error-prone because generating a valid vbaProject.bin requires deep knowledge of OLE and VBA storage formats, so I only recommend it if you can't use LibreOffice.

内容的提问来源于stack exchange，提问作者ItayNG