Hi All,
I am new to this forum and i need some help.
every week we get a xls file that we have to adjust and save as a csv.
In cell D3 we put in the date for example: "31/12/2015".
Based on the date we save the file in the correct folder for example:
the date is "31/12/2015" so i want the file be saved in Folder "2015" and in that folder a subfolder called 12.
The day we use as name. "DD31.csv"
Can someone help me how to write this code?
Thnx!!
Regards Meli
I am new to this forum and i need some help.
every week we get a xls file that we have to adjust and save as a csv.
In cell D3 we put in the date for example: "31/12/2015".
Based on the date we save the file in the correct folder for example:
the date is "31/12/2015" so i want the file be saved in Folder "2015" and in that folder a subfolder called 12.
The day we use as name. "DD31.csv"
Can someone help me how to write this code?
Thnx!!
Regards Meli