+ Reply to Thread
Results 1 to 3 of 3

Macro to delete csv files in downloads folder

  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    Lincolnshire, England
    MS-Off Ver
    Excel 2007
    Posts
    38

    Macro to delete csv files in downloads folder

    I have a macro to import a downloaded csv file to process a sale. It works well when there is only one csv file in the downloads folder; if there is more than one it imports randomly - this is unworkable. I would like to be able to import and process a downloaded csv file and then clear the downloads folder ready for the next download, so there is never more than one csv file in the downloads folder. Is there a way that a macro in an excel workbook could access the folder named downloads, delete all csv files in it, then return to the excel workbook ?

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Macro to delete csv files in downloads folder

    Hi,

    Yes ..., you can use the Kill instruction ...

    HTH

  3. #3
    Registered User
    Join Date
    09-21-2009
    Location
    Lincolnshire, England
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Macro to delete csv files in downloads folder

    Many thanks for that ! It worked well.

+ 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