What commands do you use to name a workbook, save a workbook,open a workbook

[Steven R. Berke]

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

 

[pancho]

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