Renaming files in a directory

C

Candyman

How do I rename the files in a directory? I have many reports in directory I
can loop through each file but how do i rename it? I have an input box to
assign a NewFileName. I want to keep the date suffix and change the first
part of the filename. This jams in the last line attempts. Please help. I
feel like i'm shooting inthe dark now.

If Right(myName, 3) = "xls" Then
OldFileName = myPath & myName
NameDate = Right(myName, 12)
NewFileName = (myPath & NewName & " " & NameDate)
Workbooks(OldFileName).SaveAs (NewFileName)
'Workbooks(OldFileName).Name = (NewFileName)

TIA
Candyman
 
J

JGeniti

As long as you're not trying to rename the file that you are currently
working on you can use the Name function.

Name OldFileName as NewFileName

This way you don't have to use "SaveAs"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Catching duplicate filenames when renaming a file 3
Renaming files in a directory 2
vba to copy data from sale receipt to next available column in aninventory worksheet 0
vba to copy data from sale receipt to next available column in an inventory worksheet 0
API code for 'Renaming a Directory' 2
Browse for folder - not selecting folder 8
Excluding Worksheet from Procedure 2
Command line used for opening .xls files and clicking abutton/running a function. 1

Top