Results 1 to 7 of 7

Macro to move file(s) based on wildcard description

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2007
    Posts
    9

    Macro to move file(s) based on wildcard description

    Good evening all,

    I've been working on a file tracking spreadsheet for the last few days and I am having a bit of difficulty with something I would like a macro to do.

    The basic idea of the current macro is to generate a checksum .sfv file containing filenames and CRC32s for various files and automatically give it a filename matching a template and containing today's date. For example:
    D:\SFV\A_File_With_Word_Docs-[2011-10-04].sfv
    D:\SFV\A_File_With_Excel_Docs-[2011-10-04].sfv

    This bit I have got working perfectly - however I would like to find a way of adding to this so that when a new file is being created by the macro, the 'existing' file (with a different date in the filename, most likely) is automatically either copied to another folder (as backup) and deleted, or is moved to this backup folder in one move.

    For example, on creation of A_File_With_Word_Docs-[2011-10-04].sfv, the existing file A_File_With_Word_Docs-[2011-10-03].sfv from yesterday is automatically detected (with a wildcard most likely) and the actions performed.

    I really hope that this is possible as it is a little beyond my knowledge of VBA at this stage! Thank you in advance for anybody who can help me; please let me know if you need any additional information that I may have forgotten to mention.
    Last edited by samf88; 10-05-2011 at 05:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1