i have some files that are coming daily to a folder and are replaced my new ones daily . i am using the followingVBA for catching the file and putting the X mark in the excel. But what i really want is to get the today file , sometime the today file is not delivered and the yesterday file is still sitting , so just by catching the name the code put X in the excel sheet , which i do not want.
the module code of the function is following
Doing some research some one asked me to do following thing
your FileFolderExists() function probably utilizes the Filesytem object
and has something like:
you need to EITHER modify your FileFolderExists function
to also use:
or add a variation of this to your parent macro.
(which runs if the filefolderexists function returns "true")
Dont know where to put In my code , please help
in my code
Bookmarks