Could you be a little more specific? Do you want the procedure to save the active sheet as a separate file?
To get started, you could record a macro while performing the tasks. Open the macro and view the generated source code. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.