Add a way to change workbook codeName attribute when saving spreadsheet. This allows to use dumped vbaProject code in Workbook object as-is.
Example with default codeName :
Notice that there are Workbook________ (imported code) and Workbook________1 (new) objects. And imported code is in first one, which is not active, so user needs to manually copy code.
If we change codeName to Workbook________:
No Workbook________1 entry and code now is working out of the box.
Add a way to change workbook
codeName
attribute when saving spreadsheet. This allows to use dumpedvbaProject
code inWorkbook
object as-is.Example with default
codeName
: Notice that there areWorkbook________
(imported code) andWorkbook________1
(new) objects. And imported code is in first one, which is not active, so user needs to manually copy code.If we change codeName to
Workbook________
: NoWorkbook________1
entry and code now is working out of the box.