how do i save as from a macro
 

I need to do a save as and change the file name and file location every
save.
is there an easy way to do this from a macro.


--
mkjla
------------------------------------------------------------------------
mkjla's Profile: http://www.excelforum.com/member.php...o&userid=37168
View this thread: http://www.excelforum.com/showthread...hreadid=568866

how do i save as from a macro
 

Hi Mkjla,

I need to do a save as and change the file name and file location every
save.
is there an easy way to do this from a macro.


How are the new name and location to be determined?



---
Regards,
Norman