Ron,
Thanks for the suggestion but I could not find in your pages what I need to
do.
"Ron de Bruin" wrote:
See also
http://www.rondebruin.nl/folder.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Nils Titley" wrote in message ...
Let me provide additional information.
The macro will be used by all sorts of people. I want to make it easy for
them. There is a data folder and an archive folder. The macro process any
file that sits in the data folder. After each file has been processed, a
report is generated and written to the report folder that is dated and timeed
stamped.
I want to move all of the data files to the archive folder. I can do that
now. But the person asking me to help create the macro is concerned that
there might be the same files in the archive folder. I don't think that will
happen but in case, I want to move the files and if the file already exist in
the archive folder, I would like to rename it to some thing like "filename
copy".
Does that help?
Thanks
"Nils Titley" wrote:
FSO.MoveFile
With FSO.MoveFile, can you move the files and if they exist write them with
a new name. If not how can I do that?
Thanks