Hi everybody!
I am currently trying to save a new file with today’s date in the file name and also delete the old file in the folder.
So there are two things that I would like to solve.
First, If I save the file today the file will be saved as File 10/Nov (example) and the old file that I currently opened and initiated the macro in gets deleted.
Second, If I already have saved the file and I save again later on the same day, the name would be the same, in which case I would like the file to overwrite the file. I wonder if I worded it correctly .
Would there be any solution to this?
I am currently trying to save a new file with today’s date in the file name and also delete the old file in the folder.
So there are two things that I would like to solve.
First, If I save the file today the file will be saved as File 10/Nov (example) and the old file that I currently opened and initiated the macro in gets deleted.
Second, If I already have saved the file and I save again later on the same day, the name would be the same, in which case I would like the file to overwrite the file. I wonder if I worded it correctly .
Would there be any solution to this?