from openpyxl import Workbook from openpyxl import load_workbook wb = Workbook() customer_name = "dave" # and the workaround wb = load_workbook('ANZ.xlsm', keep_vba=True) sheet = wb.active sheet["CustomerName"] = customer_name wb.save('ANZ2.xlsm')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)