Sorting error when re-opening template

[rpinxt]

All the best wishes for the new year!

But I have a macro error that is bugging me since last year
Hope you guys can explain me what is going on.

I have a small macro that opens a template, opens new data book, copies the new data into the template and closes both again.

This runs fine for 1 go. Then the next it cannot open the template anymore giving me an error like "Removed Records: Sorting from /xl/worksheets/sheet1.xml".

There is some sorting in the macro but what is going on.
Will paste the macro here it is not very big:

Please Login or Register  to view this content.

[rpinxt]

Would also be helpfull if somebody would have used a different approach for the sorting.
Maybe a different sort of sorting would not have these problems

[Fluff13]

Add this line just before the sort

Please Login or Register  to view this content.

[rpinxt]

Thanks Fluff13, but I noticed now it does not pick up when a week already exists!

They way I build that in apparently gets affected by putting in that line to lose the sorting.

[Fluff13]

I have no idea what you mean. If you do not delete previous sorts then you will get the problems you originally mentioned.

[rpinxt]

Nevermind @Fluff13, I did better testing today and your solution works like a charm.
Thanks!

[Fluff13]

Glad it's working & thanks for the feedback.