| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For loop for each file in a folder?
I've got a macro that imports a .txt file and moves the data around, an copies some things here and there... I need to run this macro on abou 40 different .txt files in a folder. Is there a way to write For-loop that will run the macro on EACH text file in a give directory? Thanks, Kiera -- Kieran102 ----------------------------------------------------------------------- Kieran1028's Profile: http://www.excelforum.com/member.php...fo&userid=1567 View this thread: http://www.excelforum.com/showthread.php?threadid=27701 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop through folder of workbooks and add rows | Excel Worksheet Functions | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Loop thru All Files in a Folder | Excel Programming | |||
| Loop through all files in a folder | Excel Programming | |||
| Loop through workbooks in a folder and return the value of cell M43 | Excel Programming | |||
![Kieran1028[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
