VB file renaming.

[El Bee]

I have a workbook that is an empty file when opened. I have a button on
worksheet 1 that when selected will import a csv file to a different
worksheet and then manipulate that date and then save it using a different
file name..
I want to check if the different file exists; if it does then I want to
purge a backup copy of the file that contains (old) as the last part of the
file name.
Next I want to rename the exist file (has not been opened) to the backup
file using the "(old") suffix to the name. I'm hoping theres a VB FILE
RENAME function that can be used to do this step.
Once the file is renamed then I want to save the opened file, where the
imported data is, to the name of the file that was prefiously renamed.
I use the KILL function to delete the old file but I can't figure out how to
rename the existing file as the backup file.

Any ideas would be greatly appreciated.

Thanks,

El Bee

 

[Rick Rothstein \(MVP - VB\)]

The statement name you want is Name and it is coupled with an As keyword;
for example...

Name "c:\Temp\Temp.csv" As "c:\Temp\Temp(old).csv"

Note the use of the path with the file name... you can only leave it off if
you use ChDrive and ChDir to set the default path. Personally, I think it is
easier to just store the path in a variable and concatenate it onto your
file names in the two locations.

Rick

 

[El Bee]

Rick,

That worked. I tried this before posting but after you replied I discovered
I mistyped one of the file names I used.
I hate it when I do that.

El Bee.