Save as

[Guest_imported]

Hello,

How can I save a file I have as another file.
I have a file myfile.mdb and want to save it as myfilecopy.mdb, while I still keep the original, that is, this is a copy.

I get the name of the file without extension as
nameoffile = left(originalname,len(originalname-4)

now, how do I save nameoffile as nameoffile & "copy.mdb" ?

Thanks,

Herts

 

[stsuing]

This may help

http://www.mvps.org/vbnet/code/fileapi/copyfile.htm

 

[RAtkison]

Create a variable with the old file name and new file name. Then use:

FileCopy sSourceFile, sDestinationFile

RKA