LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Back Up

Greetings !

If, while using Windows Explorer,
I drag a folder from one disk to another,
the files in the dragged folder
and its sub-folders are written
to the target disk - regardless.

This means that
(a) newer files may be over-written by older files, and
(b) EVERY file is copied - which can take HOURS.


Challenge 1
I want to do selective backups,
copying from the "main" disk to
a backup disk ONLY those files
more recent than a defined date
(that of the last backup).

Challenge 2
I want to do a different form of
selective backup, copying from
the "main" disk to a backup disk
ONLY those files that either do
not exist on the backup disk,
or are more recent than the version
stored on the backup disk.


My current attempts are based
upon shelling out to DOS to run

dir /s Source.lst
dir /s Target.lst

to generate text files for the two disks.

The Target list is then read in
line-by-line and stored in a worksheet
with one file record on each line,
bearing in adjacent columns
the Drive letter, the path, the filename,
the date and the size.

I then read in the other file line-by-line
and compare this entry with the
tabulated entries. When a match is found,
action is directed into a batch file
that is run upon completion.

"There must be a better way" !

Any ideas would be most welcome !


RClay AT haswell DOT com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
back ups barry Excel Discussion (Misc queries) 2 February 1st 09 07:36 PM
Tab - Back Tab Question Jenny B. Excel Discussion (Misc queries) 2 January 7th 08 02:51 AM
copy back macro/roll back moh Excel Worksheet Functions 4 March 5th 07 02:19 PM
I hid row 1 and can't get it back? Nyczoo Excel Discussion (Misc queries) 4 January 24th 06 07:22 PM
Jon - come back Wazooli Charts and Charting in Excel 0 March 24th 05 04:49 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"