Loop a macro through the multiple files
Hello members,
I have already recorded a macro and created an add-in for my CSV files.
I have more than 1000 csv files and I have to open the files one by one and run the add-in for each and then save & close.
How can I run the add-in for all files in a folder without opening each separately?
Thank you
** I have changed the topic based on the comments to find the best solution.
Last edited by Moriexcel; 11-24-2014 at 11:13 AM. Reason: added more explanation
Try to Save file which has macro as type Excel add in system default location...
then open any of your file and go to Developer options (Add Ins) It will show you available add ins stored... Select your saved Add In...
It should work in all files then......
Regards
goto excel option by click on office button, then click on Add-Ins and select Go button and then browse your addin, this will add your add-in in excel.
I have 1000+ files and I would like to run my created add-in just one time for the all files in the folder without opening the files separately.
Have you tried the same above ? ( My post)
I don't see any point in creating an add-in for that situation. Just put your code in a normal module and add a loop through all files in a folder.
I can run my add-in with no problem on all my files. The problem is I don't want to do it one by one.
Ok. Good point ! So how should I do that? Could you please help me?Originally Posted by StephenR
I'm trying to search and find it.
Last edited by Moriexcel; 11-20-2014 at 09:38 AM.
There are many examples of that if you Google - if you get stuck on something specific post back, and include your code.
Could you please help me to solve this issue?
This loop for my macro shows me 'run time error 1004' in Line 16.
Please Login or Register to view this content.
Last edited by Moriexcel; 11-22-2014 at 01:29 PM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Yes. It works. Thank you.Please Login or Register to view this content.
There is another problem.
My original recorded macro can do the work completely for one file, but I can not put Step 5 in the loop in polished version of macro (next code).
This one is the polished one. The step 5 is not included in this code.Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Moriexcel; 11-23-2014 at 06:42 AM.
****************
Last edited by Moriexcel; 11-24-2014 at 11:19 AM.
I don't really understand that code, but it might be enough to add a few dots
Please Login or Register to view this content.
Yessssssss. Many thanks Stephen & Shg.
I already clicked on '*'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks