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

This assumes that c:\mybackups exists.


legepe wrote:

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

--
legepe
------------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=271577

--

Dave Peterson