Renaming an external file

  • Thread starter Thread starter rs0905
  • Start date Start date
R

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!
 
Spoke too soon....this isn't working. Do you think I'm missing a reference
or something?
 
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?
 
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
..
 
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!!
 
Back
Top