filecopy function

[Tim]

Hi everyone,

I tried to copy all files from one folder to another
folder just like the code under DOS "copy c:\temp\*.*
c:\temp2\".

I couldn't find any function from access to this job. The
only one I found is filecopy. This function only copy a
file at a time.

Could anyone tell me any other way to do it?

Thanks.

Tim.

 

[Mat]

in vba....
dim strSourceFile as String
dim strDestinationFile as String


FileCopy strSourceFile, strDestinationFile

 

[Tim]

Allen,

Thanks for your help.

Tim.

-----Original Message-----
Pehaps you could Shell an xcopy if you don't want to loop through the Dir
process.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")




.

 

[Tim]

Mat,

I know the following function but it is not what I look
for.

Thanks anyway.

Tim.

 

[racekiller]

Destination file is getting lost...

Hi guys,

I am using same code to overwrite a file but sometimes the destination files is getting lost...some how the code is deleting it.

Do you have any idea, what could be happening?

I appreciate your help