LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rolling chart to show 13 months back from current month PBcorn Charts and Charting in Excel 2 February 7th 09 11:34 AM
How to save same excel workbook in different folders as a back up GRAPH WITH A MACRO Excel Discussion (Misc queries) 2 October 13th 08 04:35 PM
help to delete spceial folders alvin Kuiper Excel Programming 1 May 8th 06 10:02 PM
Delete an entire folders contents (or just Excel files) DejaVu[_67_] Excel Programming 3 April 7th 06 09:29 PM
delete all the contents (sub folders and files) in the temp folder Joseph Excel Discussion (Misc queries) 0 June 6th 05 08:01 AM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"