Hello everyone......I have the following code helped by someone in the forum to save a file in the said format of date and time as below. I want this code modified to do the following:
1. To create a folder named with current day's date in the format "DDDD, DDMMMYYYY" in the directory "F:\Pending File Status"
2. To save the file in the path shown below.
Please note that as this is a process which is repeated through the day.
I need code to also check if folder created in 1. above is created, if created then save the next process as in the same date folder and file path. The date refers to system time FYI.
Will someone help shed some light on this....as I am having problem sorting this out......
Just forgot to mention....this......is there a way to modify this code to save the file with the dates found in Column Q (which is a range of 3 or 6 different dates).
with formats as below.... 7/24/2017.....
So far, no one has a solution is it????
Bookmarks