Renaming File on Server via SaveAs Command

[windsurferLA]

I'm using Excel'97 under WinXP-Pro.

An .xls file posted on a server is being designed for use for a few
users. Users can download and upload the file from within Excel by
unrolling the window shade in the SaveAs|Save-In window, and pulling it
down to the appropriate internet connection.

Once one of the files on a server is selected, one can rename it from
within Excel by right clicking on it and entering the new name. I'd like
to write a macro to perform the rename task, so I can rename file-2 as
file-3, and file-1 as file-2, and file-0 as file-1, where file-0 is the
most recent and current file, without having to download and again save
each of the older files - a time consuming operation with 3 MByte files.

I've tried using the macro recorder to record the process, but other
than recording the opening and closing of the SAVE-AS box, no statements
are generated.

One need not have a file saved on a server to test the process. The name
of a file on the C:\ drive can be changed from within Excel by using
SaveAs to identify the file, and right clicking on the name. The macro
recorder does not seem to record the process.

Once again, can I implement the re-name process from within Excel with
an Excel macro?

 

[windsurferLA]

added note at bottom

I'm using Excel'97 under WinXP-Pro.

An .xls file posted on a server is being designed for use for a few
users. Users can download and upload the file from within Excel by
unrolling the window shade in the SaveAs|Save-In window, and pulling it
down to the appropriate internet connection.

Once one of the files on a server is selected, one can rename it from
within Excel by right clicking on it and entering the new name. I'd like
to write a macro to perform the rename task, so I can rename file-2 as
file-3, and file-1 as file-2, and file-0 as file-1, where file-0 is the
most recent and current file, without having to download and again save
each of the older files - a time consuming operation with 3 MByte files.

I've tried using the macro recorder to record the process, but other
than recording the opening and closing of the SAVE-AS box, no statements
are generated.

One need not have a file saved on a server to test the process. The name
of a file on the C:\ drive can be changed from within Excel by using
SaveAs to identify the file, and right clicking on the name. The macro
recorder does not seem to record the process.

Once again, can I implement the re-name process from within Excel with
an Excel macro?

for files located on the C:\ drive, one can use the a sequence of VBA
commands like that shown below, but I can't get them to work for files
on a server.

ChDir ("ftp://12.34.456.78/public_html/Actions")
Name "DownLoad-UploadTest3.xls" As "DownLoad-UploadTest4.xls"

Am I headed in the right direction?