View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sermest sermest is offline
external usenet poster
 
Posts: 9
Default copy all text files one by one and run a code.

I copy a text file and then run my code to get it to my database. I
want to do it for all ".txt" files in a specific directory. Lets say my
directory is "c:\bcf"

1. Get the first ".txt" file - copy it to "sheet2"
2. run my code "aging()", which will reorganize the data
3. copy to "sheet1"
4. get the second ".txt" file
5. run my code "aging()"
6. add to "sheet1"
7 and so for all the text files in that directory.

Thanks for your help.

Best,
Mike