Would you please provide wih the commands to name a existing workbook,
save an existing workbook, and then open the workbook. Thank you

to name a existing workbook you need to use the save as
method of the workbook, example:
ActiveWorkbook.SaveAs "NewName.xls"
The previous commnand can fail if it already exist a file
on the current directory with the name "NewName.xls", but
if you want to saveit any way you can use:

on error resume next
workbooks("NewName.xls").close false
kill "NewName.xls"
ActiveWorkbook.SaveAs "NewName.xls"

to just save the workbook with the same name it already
has you use the save command, example:
ActiveWorkbook.Save


Francisco Mariscal
fcomariscal at hotmail dot com


-----Original Message-----
Would you please provide wih the commands to name a
existing workbook,
save an existing workbook, and then open the workbook.
Thank you
.