How to process multiple open files with a macro

**garnet** · 07-22-2008, 11:57 AM

Hi all,

I have some 100 files to process, using this macro:

Please Login or Register to view this content.

it copies unique values from col A in an open file to a new file (book3). I can do this manually file by file and it appends values in the new file.

Is there a way to open the 100 files in excel and run the macro (with some modification) so it traverse thru the opened files one by one automatically and does this?

Someting like a for loop, may be?

Thanks,
Vasil

**rylo** · 07-22-2008, 09:43 PM

Hi

Can you please review the forum rules regarding wrapping code. I've edited your post for you this time.

Are all the files in the same directory as the workbook that contains the macro? If not, then where are the files to be opened, and are all the files to be actioned?

rylo

**garnet** · 07-23-2008, 07:30 AM

Originally Posted by rylo

Hi

Can you please review the forum rules regarding wrapping code. I've edited your post for you this time.

Are all the files in the same directory as the workbook that contains the macro? If not, then where are the files to be opened, and are all the files to be actioned?

rylo

Hi there, sorry for this with the code.

Yeah all files are in same folder. All the files in the folder should be actioned.

Thanks

**rylo** · 07-23-2008, 07:03 PM

Hi

Didnt' test this, but put the code below into a new workbook, and save it in the relevant directory with the files to action.

Then run the code. It should create a new output file, and copy the unique entries to that file.

Please Login or Register  to view this content.

rylo

How to process multiple open files with a macro

LinkBack

Thread Tools

Rate This Thread

Display

How to process multiple open files with a macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions