Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming files in a directory
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming files in a directory
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming files in a directory
Thats it! YES!!!
Thanks :) "JGeniti" wrote: 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintain cell links when renaming directory containing multiple f | Excel Worksheet Functions | |||
Renaming adding and deleting directory | Excel Programming | |||
Renaming Files | Excel Programming | |||
Renaming all files in a directory | Excel Programming | |||
Check if directory empty OR no of files in directory. | Excel Programming |