Would someone please post the vb code on how to copy/rename a file
within access? I have a file c:\1stltr.ltr. I would like to rename it
to c:\letter1.dbf so I can link to it. Would I use a macro or module?
Thanks!!!!!

(As you can tell, I am a nubie!)

has to be in module.
Must be in function (not sub)

Function MakeDBF()
FileSystemObject.CopyFile "c:\1stltr.ltr", "c:\letter1.dbf", true
end function

You can't rename with this set of functions.
the true at the end of the statemnt allows overwrite.

Good Lock
Ira Solomon

On 13 Feb 2004 12:20:10 -0800, forrose (AT) hotmail (DOT) com (Rosie) wrote: