run_excel_macro.py

# script to run the HHLSM model
import os, os.path
import win32com.client

# install win32com with "pip install pywin32"

HHLSM = "HHSM_2008_v3.1_PEIR_BD_VULNERABILITY.xlsm"
MACRO = "{}!HHSM_2008_v2.HHSM_2008_v2".format(HHLSM)

scenarios = [1,2,3]

if os.path.exists(HHLSM):
    with win32com.client.Dispatch("Excel.Application") as xl:
        xl.Workbooks.Open(os.path.abspath(HHLSM), ReadOnly=1) # not sure what the readonly arg value should be for updating values
        
        for scenario in scenarios:
        
            # add preprocessing here

            xl.Application.Run(MACRO)

            # add postprocessing here
        
        xl.Application.Quit() # Comment this out if your excel script closes