save as using macros

[legepe]

Can any one give me an example of how to (save as) an indipendant cop
of a spread sheet program using a macro
I am a complete newbie, and I am having problems understanding the VB
help
Thanks
legep

 

[Dave Peterson]

with activeworkbook
.savecopyas filename:="c:\mybackups\" & .name
end with

This assumes that c:\mybackups exists.