Hello
I want to open two files in vba with the same data but with different file name e.g below. Main Problem is that on daily basis files dates changes.
File1: 20210311 File
File2: 20210312 File
20210311 File contains last day data and 20210312 File contain Today data.
I want to open the 1st Today file and then the last day file and extract new records from the Today file.
After that, I want to use Today's file for further work. change in the filename on daily basis it is hard to fix the name in the code
I do not want to rename files
DO not want to pick the file because I am using files again and again.
Cross Forum Post Link
Bookmarks