Check File Date 2

[ohmbru]

I am fairly new to VBA.

Is there some code that will check the date attribute of a file before importing it?

I constantly have to check for the correct files before beginning an import process. If the new files are not there, then problems occur.

I would like to be able to abort the the macro if the files are not current date.

I still use alot of macros, but the more I learn the more I convert.

Thanks,
Brian

 

[Craig0201]

Brian,

Check the FileDateTime function in help.

HTH

Craig