Copying files into a folder from VBA code

[llafretaw]

Hi
I'm basically want to delete a file e.g "test.mdb" from a the same folder that my database e.g "calling.mdb" that is running the VBA is sitting in, and then replace it with another .mdb. I know I firstly use the Kill method to remove the "test.mdb" database,and then I was wondering how does one copy an .mdb that is of the structure as the deleted "test.mdb" but contains no data into the same folder that the "calling.mdb" is sitting in, and rename it at the same time to "test.mdb" as well. any help would be appreciated

 

[dsi]

Use Kill in conjunction with the FileCopy function.

 

[llafretaw]

cheers for that