Re: Moving Files and creating copies

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Nils

Checking if each file exist in a loop is the only way.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nils Titley" <NilsTitley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B7137A30-11E4-46FC-A980-7959B3858DB8@xxxxxxxxxxxxxxxx
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" <NilsTitley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EDEAEA01-C563-42FD-AE68-A2AE4ED3DE7F@xxxxxxxxxxxxxxxx
> 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

.

Quantcast