Hi all, I want macro to do this:
When opening excel file will check sheets("time").range("A1").
if cells is blank will set value of today => value the day opening file.
if cells have value of day will check: today subtract the day exist greater than 90 days will delete this excel file
For examble:
01/15/2020: The first time opening this file => Range(A1) blank will have value "01/15/2020"
04/14/2020: opening file => Do nothing because under 90 days from the first time opening file
04/16/2020: Opeing file => Delete itselt because over 90 days from the first time opening file
Please help me to do that by macro VBA, thanks./.
When opening excel file will check sheets("time").range("A1").
if cells is blank will set value of today => value the day opening file.
if cells have value of day will check: today subtract the day exist greater than 90 days will delete this excel file
For examble:
01/15/2020: The first time opening this file => Range(A1) blank will have value "01/15/2020"
04/14/2020: opening file => Do nothing because under 90 days from the first time opening file
04/16/2020: Opeing file => Delete itselt because over 90 days from the first time opening file
Please help me to do that by macro VBA, thanks./.