Check to see if updated first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Right now, I'm using a macro to automatically import a spreadsheet. Before I
can do that, I have to go out and see if the previous department has updated
that spreadsheet. If not, I come back to check again later.

Can Access check to see if the spreadsheet has been updated today, if so
import if not tray again in a specified amount of time?
 
The function FileDateTime() will return when the file was created or last
modified.

Syntax : FileDateTime("File Path")

Yanick
 
Back
Top