I'm doing Excel automation using Python win32com and need to remove the VBA Project passwords programmatically. Easiest way I've found to do this is by changing the vbaProject binary using the techniques described here.
The only problem with this is that it creates a minor pop-up warning when opening the file. I can't seem to suppress this with Python without going down a GUI automation route (which I am keen to avoid).
Does anybody know of a way to suppress the warning? I know many of Excel's warnings can be suppressed using the registry but I have been unable to find anything on this one specifically.
Thanks!
