Renaming an external file

[rs0905]

Is there a way to rename a file that is outside of a db? I have code where I
use .FoundFiles to locate files that match a string name. I'd like to be
able to rename the files that I find. These are text files, but the names of
the files do not end in .txt and I need them to in order to import them.

Thanks in advance!

 

[LucT]

Name "oldfile" AS "newfile"

exc. Name "c:\test.txt" AS "C:\test.asc"

 

[rs0905]

Of course it has to be really easy and I still can't figure it out! LOL

Thanks

 

[rs0905]

Spoke too soon....this isn't working. Do you think I'm missing a reference
or something?

 

[Douglas J. Steele]

What's the exact code you're trying to run?

What does "isn't working" mean? Are you getting an error? If so, what's the
error?

 

[John Spencer]

Name "c:\SomeWHere\MyFileName" as "c:\SomeWHere\MyFileName.txt"
Also take a look at the FileCopy command
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[rs0905]

I was getting a compile error on the "Name" line of code - it wasn't being
recognized at all, which made me think that I was probably missing a
reference. But, the FileCopy command did the trick. Thanks!!