Results 1 to 3 of 3

Thread: Deleting files from Excel VB

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Location
    Toronto, Ontario, Canada
    Posts
    8

    Post

    Hello )

    I have an Excel sheet that uses about 30 text files (daily captured data) one at a time to cut and past the relevat info into a template to create graphs.

    It all works great!

    What I want to do is have the macro erase or move the files from the designated temporary directory so that the next days data can be used. I need to have them removed because in some instances one or more of the files is missing and if it's not a clean directory we get corrupt graphs with data collected from different days.

    So basically what it needs to do is go to c:\temp and erase *.cap and N1*.txt

    Thanks )

    AidanEnos

  2. #2
    Addicted Member
    Join Date
    Nov 1999
    Posts
    184

    Post

    Use a kill Command if you know the file names that would be used. would that work?

  3. #3

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Location
    Toronto, Ontario, Canada
    Posts
    8

    Post

    Yes it did, thanks!

    Kill ("c:\files")

    AidanEnos

Posting Permissions

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



Click Here to Expand Forum to Full Width