VBA - File and Folder Procedures - Worth a look!!!

[Bowers74]

And another FAQ: FAQ707-4116

This is a rather long FAQ that contains ways of checking for, copying, moving and deleting files and Folders using VBA.

Don't forget to vote for the FAQ at the bottom of the page. I like to know if my FAQ's are useful or not. If you have any suggestions, then send me a reply and I will revise the FAQ (or any of my other FAQ's). ;-)

Enjoy!

P.S. I changed this to a Helpful Tip because I posted it as a question first and don't know how to change it back.




Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[mrmovie]

hi Mike,
like your posts. only feedback i would say in regards to your FAQ would be the use of functions rather than subs. it would make them more reusable. that way people could pass the function some parameters, files to copy etc, or an array of files to delete etc and the function would wrap this and return a nice code to say what had happen. this would make it re-usable
keep up the good work
rich

 

[Bowers74]

Just in case anyone else is interested!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!