View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Rename workbook upon closing

Hi,
Can I have my workbook renamed upon closing and make the name the date which
is found in cell al of sheet named "patrol log". Two twists to this request
is that (1) I want to make the name consist of a constant "Patrol Log" with
the date from the a1 cell following, ex: Patrol Log 10-18-04. (2). I do not
want to have a save as request performed because that ends up keeping the
original workbook around, I want a rename request performed so that the
original is not saved.

I hope someone can help
Thank You,
Brian