move - How to use VBA to delete multiple xls files -
using vba access how delete multple xls files ? there 3 reports generated through process being saved documents folder. in same sense how move 3 of these files folder if didn't want delete them archive them?
dim fso new filesystemobject fso.deletefile "c:\mydocs\*.xls"
or
fso.movefile "c:\mydocs\*.xls" "c:\archive\"
Comments
Post a Comment