Rolling back 'folders delete' using VBA
Hello,
(Environment Excel 2003) (operating system Windows XP professional)
I am deleting a root folder in a vba macro using filesystem object. This
root folder has many subfolders in it.
If any of the files (any type of the file) in any subfolder can not be
deleted for any reason (such as if file is read only or already opened in an
application) then I get 'permission denied' error. At this point I want to
rollback the entire deleting process.
Basically on any type of error while deleting the root folder I want to
rollback the deleting process.
Any ideas or suggestion as how this can be achieved programmetically in
Excel macro.
Thanks in advance
Nayan
|