What commands do you use to name a workbook, save a workbook,open a workbook
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
.
|