Renaming an Excel File

[DanSc0tt]

Any idea what piece of code I can use to rename an excel file on my desktop from inside Access, I have seen the simple "kill" command to delete stuff, but wondered if there was a similar one to rename stuff??

Dan

 

[jgoodman00]

I have never seen a specific rename function, but a way of acheiving this, is to use FileCopy function & give the destination file your 'rename' name. Then use the kill function to delete the original file...

e.g
FileCopy("c:\SourceFile.xls", "c:\DestinationFile.xls&quot
Kill "c:\SourceFile.txt


Check the syntaxes first though... James Goodman

 

[tlbroadbent]

Use the Name function in Access VBA.

Name Statement Examples from Access Help.

Dim OldName, NewName

OldName = "OLDFILE" ' Define file names.
NewName = "NEWFILE" ' Define file names.

Name OldName As NewName ' Rename file.

OldName = "C:\MYDIR\OLDFILE"
NewName = "C:\YOURDIR\NEWFILE"

Name OldName As NewName ' Move and rename file. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.