VBA Code Required

[hrayani]

Hello Friends,

I need a VBA code which could do the following

1) Go to each file (regardless of the name) in a folder named "Test Folder" located at "D: Drive"
2) Delete a worksheet named "123" from that file
3) And select worksheet named "abc"

In case if the file "123" which is supposed to deleted is not found then close that file as it is

Any help would be appreciated

Regards,

Humayun

 

[Marc L]

​

As experimenting is learning so well done ‼​