Hello there,
After some attempts to use already written functions, i need your help on my current problem..
I have a WB used to classify my data, in the sheet 1 all my datas are stored.
I have to create for every week a new XLS with only the values (mostly relatives fields in this sheet) and to save it in a particular folder, let's name it direction. His name is always the same, let's say yearmmdd, filesfollowing_currentweeknumber.
It's obvious that for the next year it have to be on a new file.
I need a msgbox to confirm the saving and the directory and the success of the operation !
Thanks for your time and consideration!
Best regards !
Bookmarks