+ Reply to Thread
Results 1 to 2 of 2

Delete previous weeks file?

  1. #1
    Registered User
    Join Date
    01-12-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    20

    Delete previous weeks file?

    Hi,

    im trying to use a macro to delete a week old file, i know the file name begins with a date so im simply searching for: "02-04-2013 - myfile.xlsm"

    but it keeps spitting out Runtime Error 75, sometimes it works more often than not though it doesn't?

    Please Login or Register  to view this content.
    the file path and name the macro generates and searchs for matchs like for like but it still has issues?

    Any ideas?

    Thanks.

  2. #2
    Registered User
    Join Date
    01-12-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Delete previous weeks file?

    Forgot to add, when i debug its going string to the last bit of code:
    Please Login or Register  to view this content.

+ 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