Renaming a file

Enkay62 · Sep 17, 2003

Hi.
How can I rename a file (in a different directory) via vba?
Thank you.
Nick

SkipVought · Sep 17, 2003

Hi,
Use the SaveAs Method.

There are several arguments, so I can't tell you what you'll need, but the simplest is...

Code:

ActiveWorkbook.SaveAs FName

where FName is the path and filename.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

RiazKhanmohamed · Sep 17, 2003

use the copy command to copy to a new location, then use the kill command to remove the original.

Hope this helps

TPetersonFlorida · Sep 17, 2003

use the filesystemobject, way easier than the copy command and kill command and its a standard VBA object.