keep visual basic for real world business
Many businesses use programs like Peachtree, or even very large platforms like Meditech and Epic in Hospitals. They do not always have good implementations, and as a way to salvage poor operations we use data dumps into excel. The way the vast majority of power users have used this in the past is to use VISUAL BASIC to automate TONS of data manipulation. I have found, very clearly, that Office 2010 64 bit can be rolled out to several people and shared excel files with visual basic in them work fine. If one person has office 2013, or 2016 or 365 64 bit and they use the same file, it corrupts the file. It does something wrong to the visual basic inside it. I can then open the file into a 32 bit version of excel and re-save it, but then the code does not work. Certain commands confuse excel and visual basic and it does not recognize it as a VB command. So you then have to insert in front of certain lines of VB code. To see your issues, you need 4 PC's, two with office 2010 64 bit (which works, so WHY are you taking it away! ) and one with Office 2016 64 bit and one with office 2013 64 bit. Make a file using VB code, variables etc. Edit it on one 2010 PC. Run the file on both 2010 PC's to see it works. Then open the file and run it on the 2016 PC.