Hi;
I need to copy last work day's data into my current worksheet. Last work day's data can be found at K:\Downloads_Uploads\Downloads\Daily\GV8 downloads\2015\December\1214.xlsx. I know the code that open the file, copy and paste the data, but the difficulties I met are that how can I define the variables and create the path as year, month and date changes. (for example, today is Dec 15, so I need to open file from K:\Downloads_Uploads\Downloads\Daily\GV8 downloads\2015\December\1214.xlsx, but if today is Monday, Dec 21, then I need to open file K:\Downloads_Uploads\Downloads\Daily\GV8 downloads\2015\December\1218.xlsx).
I appreciate if anyone can give me a help.
Chris
Bookmarks