Macro to open every file in a folder, run a certain macro and close each file.

**masben** · 01-12-2013, 01:30 AM

Hi

I have folder with a lot of files. Each one of these files contain a macro called "crunch". Instead of open every file by itself and run the macro I would like to be able to run a macro from a diffrent file that opens each file in the specific folder - runs the "crunch" macro - save the file and close it. I can manage to run a macro in one other file but not step through all files in a folder.

Anyone having a solution to this?

Thanks!

**Trebor76** · 01-12-2013, 02:24 AM

Hi masben,

Try this - just change the 'strMyDirectory' variable to suit:

Please Login or Register  to view this content.

The only thing is that I couldn't get the macro to run if the macro name was variable which is OK in this case.

Regards,

Robert

**masben** · 01-12-2013, 09:51 PM

Robert,

This works exactley as I wanted it to do - PERFECT - THANKS!

Do you know if it's possible to ad like a pop up window when running the macro that asks for the directory and name of the macro to run? I'm very happy with the answer I already got but this would be a nice bonus :-)

Thanks again,
Martin

**Trebor76** · 01-13-2013, 12:14 AM

Hi Martin,

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

**masben** · 01-13-2013, 01:02 AM

Great!

This makes the macro useful in many other applications aswell.

Thank you very much Robert.

All the best,
Martin

**Trebor76** · 01-13-2013, 01:45 AM

Hi Martin,

Thanks for the feedback and for adding to my reputation

I'm glad we were able to provide you with a suitable solution.

Regards,

Robert

**masben** · 01-14-2013, 04:52 AM

Robert - never mind this one..

I solved it mysef :-)

//Martin

Hi again Robert,

I tried the macro again and it seems like the files that are opened are not closed after the macro has run. Must have missed this when I tried the macro at first.

Guess this is a pretty easy fix for a guy with your skill :-)

Thanks,
Martin

**masben** · 01-14-2013, 05:35 AM

Robert,

Do you know what would be EVEN better? :-) Instead of entering the directory to the files... is it possible to browse the directories at your computer??

I feel I maybe pushing it but worth asking (and I promise I will add even more to your reputation :-) )

Thanks again,
Martin

**masben** · 01-14-2013, 05:45 AM

Originally Posted by Trebor76

Hi Martin,

Thanks for the feedback and for adding to my reputation

I'm glad we were able to provide you with a suitable solution.

Regards,

Robert

Hi Robert,

Would it be possible to instead of entering a directory path - browse your computer and select the directory??

This might be pushing it - I promise to add even more to your reputation if you fix this :-)

Thanks (again),
Martin

Macro to open every file in a folder, run a certain macro and close each file.

LinkBack

Thread Tools

Rate This Thread

Display

Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Re: Macro to open every file in a folder, run a certain macro and close each file.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions