I may be missing the point here, but could you use 'savecopyas' from inside your macro ?