View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pancho[_10_] pancho[_10_] is offline
external usenet poster
 
Posts: 2
Default 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
.