I have around 2000 reports that all have a one sheet with the same name I need to be removed per a client’s request.
a)I was wondering if there is a macro that will allow me delete a specified sheet on all workbooks within a folder.
(I think the thread I have attached deletes a sheet but I am a bit of a novice and have not been able to get it to work properly.
http://www.excelforum.com/excel-prog...html?p=2895807)
b)Then after I process all of the reports remove the macro from all of the workbooks so clients do not think they have a virus.
Bookmarks