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

S

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top