AddVBAProject limitations

[JDavidVR]

Description
I'm trying to use AddVBAProject function but it has its limitations when vba code is in ThisWorkbook

I've created a file using MS Excel 2010

So I've extracted the vbaProject.bin from the above file and use it to add to a file generated with excelize, and it looks different

Steps to reproduce the issue:

1. Create a file manually using excel, and add code to ThisWorkbook for example MsgBox "Hi..!!"
2. Extract the vbaProject.bin
3. Execute this code

f := excelize.NewFile()

if err := f.SetSheetPrOptions("Sheet1", excelize.CodeName("Sheet1")); err != nil {
    fmt.Println(err)
}

if err := f.AddVBAProject("vbaProject.bin"); err != nil {
    fmt.Println(err)
}

if err := f.SaveAs("macros.xlsm"); err != nil {
    fmt.Println(err)
}

4. Open with Excel, it won't execute the vba code

Describe the results you received:

Describe the results you expected:

Output of go version:
go version go1.17.6 darwin/amd64

Excelize version or commit ID:
branch: master
commit: ad09698515b4f70496c950cca02ce612af8170e0

Environment details (OS, Microsoft Excel™ version, physical, etc.):
macos Big Sur 11.4

Investigation
I've compared files between:

• File generated manually
• File generated with go

Results: excelize generated all the necessary information BUT it has some missing changes for xl/workbook.xml

By MS Excel

<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
          xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
          
          <workbookPr codeName="ThisWorkbook" defaultThemeVersion="124226"/>

By Excelize

<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
          xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
          xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15">
          
          <workbookPr defaultThemeVersion="164011" filterPrivacy="true"></workbookPr>

So:
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15" this line it's causing the issue
and
<workbookPr tag need and additional param codeName="ThisWorkbook"

[JDavidVR]

@xuri I've created a PR, the quick solution would be modify the template for workbook 9144ff1