from openpyxl import Workbook
from openpyxl import load_workbook

wb = load_workbook('Test.xlsm',keep_vba=True)
ws = wb['Sheet1']
ws.cell(row=1,column=1).value = 9999999
wb.save('Test.xlsm')

— Permalink