Macro to save file to a specific directory depending on the day of week

R

robertguy

Many thanks to icestationzbra & AlfD it worked a treat

However,

can anyone please advise me how to incorporate both the time and dat
into the formula " & trim(format(date,"dd-mmm") & ".xls")

Many thanks



Rob :
 
Top