Renaming input file

  • Thread starter Thread starter Tom Knox
  • Start date Start date
T

Tom Knox

I'm trying to rename an input text file from my C drive on my PC prior to
transferring to file to my Access application. How do I define the file so
that I can use the docmd.rename in a function.

Thanks for any help

Tom
 
Use the statement in VBA:
Name <OriginalPathAndFilename> As <NewPathAndFilename>

For example:
Name "C:\Test.dat" As "C:\MyFolder\Test.txt"

Not sure what you mean by "define the file"?
 
I thought I had to define it somewhere in my Dim and Set statements. But
your solution worked!! Thanks alot.

Tom Knox
 
Back
Top