aioliaexcel
New Member
- Joined
- Sep 24, 2014
- Messages
- 3
Hi all,
I have to open three files everyday. The file's name is: xxx 09-24-2014. The date will be changed every business day. I have to go to the folder where all these files are saved: Folder's year>Folder's month>the files and open the files.
let say today is 9/24. I have to open three files, 1 business day, 2 bd and 3 bd prior to today everyday. the files name would be: xxx 09-23-2014, xxx 09-22-2014 and xxx 09-19-2014.
Is there a macro code for this?
Also, I want to copy and paste all the three files contents.
Thanks for your help!
I have to open three files everyday. The file's name is: xxx 09-24-2014. The date will be changed every business day. I have to go to the folder where all these files are saved: Folder's year>Folder's month>the files and open the files.
let say today is 9/24. I have to open three files, 1 business day, 2 bd and 3 bd prior to today everyday. the files name would be: xxx 09-23-2014, xxx 09-22-2014 and xxx 09-19-2014.
Is there a macro code for this?
Also, I want to copy and paste all the three files contents.
Thanks for your help!