+ Reply to Thread
Results 1 to 4 of 4

Can Someone Please Amend This Macro

  1. #1
    Registered User
    Join Date
    04-26-2007
    Posts
    94

    Can Someone Please Amend This Macro

    Hi guys. I really need someone to amend this macro for me if possible please!!!

    Please Login or Register  to view this content.
    The macro will basically look for any files containing the word "Exceptions" in its filename and move them to a folder called EXCEPTIONS.

    I would like a few amendments to this macro if possible:

    1. I would like the macro to search in 2 specific locations for files containing "exceptions" in their filename:

    ThisWorkbook.Path & "\FORMATTED"

    and

    ThisWorkbook.Path & "\ONE - FORMATTED"

    2. I would like all of the applicable files to be moved into a folder called EXCEPTIONS located at:

    ThisWorkbook.Path & "\EXCEPTIONS"

    Note: This folder may need to be created.

    If someone could do this it would be very much appreciated.

    Thanks!
    Dave

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I gave you code the other day that moved files

    http://www.excelforum.com/showthread.php?t=608714

    That code worked fine when i tested it.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    04-26-2007
    Posts
    94
    Hi Roy,

    Its not quite working properly. I posted a reply at:

    http://www.excelforum.com/showthread.php?t=608714

    Where shall we discuss this?

    Thanks
    Dave

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    It's best to stick to one post

+ Reply to Thread

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