How VB 6.0 code can be written to copy all Excel or Word file in a specific location at a specific time?

Dear Friend



I want to design a program in VB 6.0 to copy all Excel or Word file in a specific location at a specific time.



Please help by providing the code in detail.



Regards

AshishHow VB 6.0 code can be written to copy all Excel or Word file in a specific location at a specific time?
You will need use timer control. Using this control, you can define how much time it will wait till run code again.

In this control events, you will point to a sub that will copy the files.

Your code to copy the files will be like this:

Sub CopyFile()



FileSystemObject.CopyFile ';c:\*.xls';, ';c:\tempfolder';



end Sub