Copy a file with a macro in it

[voodoo]

Is it possible to copy an Excel file and maintain all the macros contained in it. But I dont want to actually save the resulted copy.

I am puting data in a format based on a template in this file I want to copy but the resulting output is to remain open in Excel unsaved. The user will later save it by theselves.

Thanks for any advice