nanscombe
Registered User.
- Local time
- Today, 07:00
- Joined
- Nov 12, 2011
- Messages
- 1,081
I'm WAAAY out of date and still use VBA that I have used for over 10 years.
There is probably a way of deleting files using FileSystemObject but I still use the KILL Pathname command, be careful because it doesn't offer any second chances.
Another possibility would be to use NAME SourceFile AS TargetFile to move the file to another (existing) directory. Once they've all been moved, and you've checked them, you can delete them in one go using Windows Explorer.
I learnt VBA by using various flavours of BASIC for nearly 20 years, that and Microsoft Help.
There is probably a way of deleting files using FileSystemObject but I still use the KILL Pathname command, be careful because it doesn't offer any second chances.
Another possibility would be to use NAME SourceFile AS TargetFile to move the file to another (existing) directory. Once they've all been moved, and you've checked them, you can delete them in one go using Windows Explorer.
I learnt VBA by using various flavours of BASIC for nearly 20 years, that and Microsoft Help.
Last edited:
