none
File corrupted after creating the second document based on template with macro RRS feed

  • Question

  • I have many Excel templates containing VBA code. Some of them create new document based on other templates with VBA code. They all worked well until last Friday, but today I got a bad surprise: creating the first document based on a template with macro works well, but creating the second gets corrupted code.

    I was able to reproduce the problem with two very small templates created from scratch:

    1. double click on the first file to create the first document
    2. double click on the second one to create another document

    At this point you can see on the VBA editor that the VBA project for the second document is corrupted. Using first the second template, then the first one will corrupt the second one that is opened.

    Click here to get the files to reproduce the problem.


    Monday, June 3, 2019 8:37 PM

All replies

  • After talking with Microsoft support and testing with different computers, we confirmed that this is a regression of Excel 1905.

    Tuesday, June 4, 2019 1:25 PM