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

  • Thread starter Thread starter robertguy
  • Start date Start date
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 :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to save file to a specific directory depending on the day of week 3
How to get an Excel file to save without the VB 2
Day/Date/Week 3
Spreading date range across days in weeks (advanced) 7
Macro to Save File to specific location when closing 3
run different macro depending of the day of the week 2
Using VBA to change a cell format to date doesn't get "committed" 3
A curly date problem 4

Back
Top