Startup Idea: Building a Version Control System for Macros

Startup idea to develop a mod or environment that can interface with VBA to run and test macros in an external, sandboxed, or emulated environment. This software should show the effects of the macro on the current MS application file, without affecting the actual file, and have a terminate button to prevent infinite loops.

I am a data manager for a major credit ratings company. For many daily tasks, we are still using MS Excel, Access, and TOAD for SQL. A major portion of my job is to build macros for various office applications.

One of the major headaches for building Macros is a lack of version control solutions that are simple and easy to interface with VBA. This is especially true when testing a macro. One must always save the given file before testing the macro. If the macro doesn't work, the "undo" will not undo any changes.

So, short of manually undoing all changes, one has to close and reopen the workbook.

This is especially true in the case of Do-Loops, as if for any reason one gets stuck in a n infinite loop closing is the only option (sometimes with ctrl-alt-del).

I would like a mod, or environment that can be activated while building a macro to run the macro in an external, sanboxed, or emulated environment that will show the effects of the macro on the current MS application file without effecting the actual file. This test environment should be equip with a "terminate" button in the event of infinite loops. Right now I simply do the procedure above. I cannot find any good solutions online.