Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016
    Posts
    1

    Default Copying a file by creating a new file each time.

    I am trying to take an Excel file from one location and copy it to another location. I do not want to copy and replace, but rather once a day take a version of the file and make a new file each time it copies over to the backup location. A preferable format might be "table111516.xls" for copy today, then "table111616.xls" for the copy the next day. It could also be 01, 02...

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,618

    Default

    Hello,

    BC3 supports one level of backup, but not more than one (to create each day). The solution would be to use the copyto script command, which can take an arbitrary location, and add %date% to the destination path:
    load "c:\folder1" "c:\destination"
    select left.newer.files left.orphan.files
    copyto "c:\destination\backuppath%date%"

    This would create a new folder for each backup, and give that folder a name containing the date. We do not have a method of appending the filename itself.
    Aaron P Scooter Software

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •