I have several workbooks 100 files minimumn in a folder C:\backup2016\ in which there are named ranges but actually using code below which is mandatory that file is open to activate macro

Note that the workbooks has several sheets

I am looking a macro that when triggered delete from folder backup 2016 all named ranges are deleted in those excel files 

Please Login or Register  to view this content.