View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jkt jkt is offline
external usenet poster
 
Posts: 3
Default How date stamp & save filename?

I want to save a file as its original filename with today's date applied to
the end of the filename.

For example:

filename = budget.xls

I open, make changes, etc., click macro button. File is saved as
budget_5-7-2007.xls

Can someone help me do this? I wan the same directory location as the
original file to be used when saving.

thanks,
jkt