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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -