Hello all, Greetings...
I have finished macro coding to merge data from one file to another file. My problem lies here.
I have a hundreds of files in the folder
TAB05JUN2020.CSV .....so on
and the second set of files in the same folder
I want to open a file TAB01JUN2020.csv (this is master file), after that I have to open another file checking the same date as is the master file i.e., RTD01062020.csv and merge the data using Macro which is I already done.
My question is how to open same set of date files and do the macro work. If TAB01JUN2020.CSV opens then automatically it will check the same date and need to open the RTD01062020.csv file and do the macro job.
I request you to all please help in this regard.
Thanks with regards,