I have an excel database. It consists of thousands of .xls files filled with information. The info is in the same corresponding cells in each file. Then, I have a template that loads the data and does calculations, allows me to toy with the numbers, and print.
The problem is that upon adding some new features I have encountered a problem saving the data from the template back into the .xls files. This stuff is coded in super old excel legacy code.
Is there some way I can add a new vba quit button that when I click quit it closes all of the files and gives me the option to save/dont save?
The problem is that upon adding some new features I have encountered a problem saving the data from the template back into the .xls files. This stuff is coded in super old excel legacy code.
Is there some way I can add a new vba quit button that when I click quit it closes all of the files and gives me the option to save/dont save?
