vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
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 1st Today file and then last day file and extract new records from Today file.
After than I want to use Today file for further work. So I need to open it again.
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 1st Today file and then last day file and extract new records from Today file.
After than I want to use Today file for further work. So I need to open it again.