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
TAB01JUN2020.CSV
TAB02JUN2020.CSV
TAB03JUN2020.CSV
TAB04JUN2020.CSV
TAB05JUN2020.CSV .....so on
and the second set of files in the same folder
RTD01062020.csv
RTD02062020.csv
RTD03062020.csv
RTD04062020.csv
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,
Babu