Don't quite know what you want to do about it, but this shows how to use VBA to check the file date:
Dim strMyFile As String
strMyFile = "C:\MyFolder\MyFile.txt"
If DateDiff("d", Now, FileDateTime(strMyFile))
Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure:
First, sum up all the individual digits in the number
If that sum value has more than one digit, then sum up …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …