save as using macros
 

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

--
legep
-----------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27157

save as using macros
 

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