Run macro in all files from a folder

**CassioGodinho** · 04-22-2012, 02:25 PM

Earlier I posted this thread:
http://www.excelforum.com/excel-prog...worksheet.html

mrice nicely solved my problem but now I have another one.

I need to run the macro I just created on 500 + files, and those files are not excel workbooks (*.xls). They are pure text files that I open with excel and then the excel do the job of converting tabulations in columns.

The macro Im using is this

Please Login or Register  to view this content.

I have no idea where to start, most of my "googling" takes me to threads teaching how to activate a pre-existent macro on a bunch of files.

**Chippy** · 04-23-2012, 11:41 AM

Open one of the text files with the macro recorder running to generate the basic VBA code for opening a text file (Text Import Wizard). Edit the code to incorporate a Dir loop (see VB Help or Google) to loop through the 500 files. For each file, open it, call your existing code (which you will probably have to modify slightly), then close and save it (use the macro recorder again to generate the VBA for saving a file).

Run macro in all files from a folder

LinkBack

Thread Tools

Rate This Thread

Display

Run macro in all files from a folder

Re: Run macro in all files from a folder

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions