I found this code in this forum and tried to modify to create a folder in F drive as “Development”
and then tried to save an excel file “Collection.xlsm” into that folder.
I am stuck and unable to move forward. Expert opinion on this is needed.
What I want to do here are as follows:
I want to check in the F drive if a folder named “Development” is present already.
If folder is not present, I want to first Create a Folder named “Development” in that F drive.
Then now I want to check in the folder “Development” if an excel file “Collection.xlsm” is present; if not present then Create the excel file “Collection.xlsm.”
If the excel file “Collection.xlsm” is present then to save the file with the current date and system time which has the format “Sunday, 30Jul2017_01-41-33 PM” added to this file and saved as “Collection Sunday, 30Jul2017_01-41-33 PM.xlsm”
Tried my best to explain it, but your valuable queries on it is welcome.....
Please Login or Register to view this content.
Bookmarks