W
wrvadmin
I need help in creating a macro that will prompt the user who opens the
workbook to automatically save the workbook with a new file name. I have a
workbook that is revised on a daily basis and I want to maintain the previous
day's file. I am generally the one who opens the workbook, but there will be
days when someone else opens it on their computer. It doesn't have to be a
mandatory save, but I want the prompt there as a reminder to save with a new
filename.
workbook to automatically save the workbook with a new file name. I have a
workbook that is revised on a daily basis and I want to maintain the previous
day's file. I am generally the one who opens the workbook, but there will be
days when someone else opens it on their computer. It doesn't have to be a
mandatory save, but I want the prompt there as a reminder to save with a new
filename.