I need to write a excel macro in that will open a excel files and run a macro on them. The name of those files will be changed in the next day. can somebody help me to develop a macro that will open a excel files that names of those while will be changed time to time?