With the VBA below, what code do I insert and where so that the file can be
saved in this directory ~ "R:\Daily Revenue Report\Daily Revenue\" ?

ActiveWorkbook.SaveAs Filename:=InputBox( _
prompt:="PLEASE ENTER NEW FILENAME ", _
Default:="Yesterday's Date"), CreateBackup:=True

Greatly appreciate any and all assistance from anyone! :-)

P/S - A Happy New 2007 to one & all :-)