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 !