Macro for Moving xls files

[Nithya]

Hi Gurus,

I am looking for some macro which will move all the xls files from a directory say C:\temp to C:\Archive, we have a process which will convert the xls to csv after this we have to move the xls files to archive directory.,

can any body help me with this.


--Nithya

 

[Blade Hunter]

Does it need to be a macro? You could use a batch file with the folowing:

MOVE C:\temp\*.xls C:\Archive

You can then set this batch file up as a scheduled task.

Cheers

Dan