You can use SaveCopyAs with code to save the file in the folder you want and with the name you want
ThisWorkbook.SaveCopyAs "C:\Data\yourfilename.xls"
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"mcphc" wrote in message ...
Lets say an excel file A.xls has been opened and has had some changes made
to it but not saved. Is it possible in VBA to save this file as B.xls
including the changes and have file A.xls still open in excel so that if
the file were to be closed you could still select to save the changes or not?
Thanks
Clayton