Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename file

Status
Not open for further replies.
tdonahue

tdonahue

Technical User
Feb 4, 2001
50
0
0
US
I am trying to develop a macro to rename a unnamed file to a text file. What command would I use?

Tom
 
Sort by date Sort by votes
Something like this in VBA ?
Name oldpathname As newpathname

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
You can try using FileSystemObject
Code: 
Dim oFso As Scripting.FileSystemObject
Set oFso = New Scripting.FileSystemObject
oFso.MoveFile "C:\9.txt", "C:\1.txt"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access 3
Replies
13
Views
112
TheresAlwaysAWay
TheresAlwaysAWay
lameid
  • Locked
  • Question
Print To File With Adobe PDF Printer
Replies
0
Views
39
lameid
lameid
Knicks
  • Locked
  • Question
LDB File Chinese Characters (Access 2013) 1
Replies
2
Views
96
Knicks
Knicks
KeyserSoze
  • Locked
  • Question
Import Error Files - Export$_ImportErrors
Replies
1
Views
53
Andrzejek
Andrzejek
weberm
  • Locked
  • Question
Problems with the text file generated by exporting Access 2013 to a delimited text file
Replies
16
Views
126
weberm
weberm

Part and Inventory Search

Sponsor

Back
Top