Craetion of folder in VBA

[Sharath]

hi,
I would like to know the code for the following problem.
1.Create a folder containing excel sheet
2.The file name should be "week_date"
3.Then i would want automatic creation of folder and excel with increment in "week_date", but here the excel sheet content to be copied from previous folder.
Here the automatic increment should happen once in 3days.
-------------------------------------------------------------------

I have also tried coding, but it didn't work, i was able to create a folder and excel sheet, but automatic increment not possible.



Thanks in advance

[chubzyko]

automatic increment? hmn.. what do you mean? you want to copy the excel sheet from a folder to a new folder and overwrite the existing excel sheet there? and that shoould happen every after 3 days? well, that's what I think of what you wanna do. If not, then plz correct me. ;p anyway, why dont you just put your program in the scheduled task so that it will run every mondays and thursday?