View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helena Helena is offline
external usenet poster
 
Posts: 10
Default Test for File Creation Date

I have a workbook which runs a macro to import various files and run
reconciliations between them. Problem is that those files need to be current
- ie. the VBA needs to test the files BEFORE the import process starts and if
the source files don't have today's date then the user needs to be notified
and the process prevented from running.

I think I can do it with adding a reference to Windows Scripting or
something, but how do I guarantee that my user(s) will also have that
reference?

Any help gratefully received!
Thanks
HMA