LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code error in creating text files Greshter Excel Discussion (Misc queries) 3 January 15th 06 09:34 PM
copy subfolders, replace text in files and save files in copied subfolders pieros Excel Programming 0 November 1st 05 12:08 PM
open some txt files ,find text , copy the text before that to a single cell gus Excel Programming 2 July 11th 05 05:40 PM
Code-Copy & Paste in Text Boxes Bourbon[_27_] Excel Programming 1 January 28th 04 12:53 AM
Copy text files into multiple sheets of 1 workbook Steve[_56_] Excel Programming 0 January 14th 04 08:30 PM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"