How to rename an active workbook

[ykumar]

Hi,

Can any one tell me the BVA code for renaming an active excel fil
based on a ceratin cell's text value.

thanks in advance
Yoges

 

[Frank Kabel]

Hi
with activesheet
..name=.range("A1").value
end with

 

[Don Guillett]

Save as another name

ThisWorkbook.SaveAs Filename:=FName

the use KILL (look in HELP) to kill the origina.