Access renaming a file

[notDave]

Can anyone direct me to a sample line of code I can put in
a module that would copy a file from the C: drive and give
it a new name?

Something like;
ren (c:\test.txt, c:\test2.txt)

~notDave

 

[Alex Dybenko]

Name "c:\test.txt" AS "c:\test2.txt"

 

[notDave]

How about copy?

And thanks for the tip in shellexecute, i'm looking at it
but all that error trapping is hiding the actual code

~notDave

 

[Dirk Goldgar]

Can anyone direct me to a sample line of code I can put in
a module that would copy a file from the C: drive and give
it a new name?

Something like;
ren (c:\test.txt, c:\test2.txt)

~notDave

FileCopy "C:\test.txt", "C:\test2.txt"

 

[notDave]

Great! Thanks!

Is there a layman's list anywhere of those?

MkDir
Name
FileCopy

etc?

~notDave

 

[Dirk Goldgar]

Great! Thanks!

Is there a layman's list anywhere of those?

MkDir
Name
FileCopy

etc?

It's in the online help, in the VB section. You should be in the VB
Editor when you open help, if you want to see these topics.