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

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" wrote in message
...
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,

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.



"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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