From what platform do you want to do this (baring in mind that VB does use macros, VBA does.)?

Also, why do you want to do this espcially without providing the user the opportunity of saving their work? This sounds a bit suspect.