saving xlsm file results in error & non-working Macros
Created originally on Bitbucket by skmor (S.M.)
OS: OS X Python: 3.4.1 Office: 365 on Windows
Issue: Excels throws out a "repairing error" on renamed workbook, macros become unclickable.
I've read much about the problematic nature of xlsm files, and Excel's useless debugging tools after throwing the "worksheet was repaired". If anyone here can offer help nevertheless, it'd be super.
Below is the relevant piece of code:
#!wb2 = load_workbook(os.path.expanduser(path_to_file), keep_vba=True) # open workbook NEED CHANGE
wb2.active = 9
#print(wb2.active)
#ws = wb2.get_active_sheet() # get the active sheet
#ws['E2'] = 5
wb2.save(os.path.expanduser(path_to_temp))
As you can see, I even commented out the actual writing, and still just opening the file and saving to a new file results in an error that deems the workbook unusable. Unfortunately the workbook itself is a little sensitive so I can't just attach it, I'm wondering if maybe I'm missing a certain package/version/detail?