edit macro to make it run on all files in a folder

[rohit43]

Hi! All,

Please find a macro below. All I want is to edit this macro so that it runs on all the files in a particular folder

Please Login or Register  to view this content.

[rohit43]

can anyone edit the above mentioned macro so that it runs on all the files in a particular folder

[HaHoBe]

Hi, rohit43,

you could have edited the originla post instead of reposting.

Maybe like this (untested)

Please Login or Register  to view this content.

But I strongly doubt that you have a lot of workbooks with a sheet named Jun8 in that folder.

Ciao,
Holger

[rohit43]

Hi! Holger,
I am sorry to say but this didn't work. I am not very good with macros. The one posted was actually recorded by me. Can you edit the same macro so that it automatically runs on all the workbooks in a particular folder.
All the workbooks in the folder are exactly the same with different workbook names. And the the workbook contains same sheets with same sheet names. The comments on each workbook are different as they are filled by different users.

[HaHoBe]

Hi, rohit43,

I am sorry to say but this didn't work.

Could you be a bit more specific about what didnīt work? Any error messages put up, error numbers shown, files not opening, no new sheets entered?

Can you edit the same macro so that it automatically runs on all the workbooks in a particular folder.

Have you tried your macro on more than one file with success?

I wouldnīt rewrite all the code (since my efforts didnīt work) but use a wrapper for opening and closing the files and use the existing macro to do the work (which could need a good boost of work):

Please Login or Register  to view this content.

Ciao,
Holger

[rohit43]

Hi! Holger,

Could you be a bit more specific about what didnīt work?

No new sheets were entered

Have you tried your macro on more than one file with success?

Yes it works on all other worksheets in that folder if I run it seperately on each one of them.

As I said earlier, I am not good with macros. I can only record macros and run a given macro. I am not able to understand the macro that you have given me. I don't know if I need to add this to my macro or run it as a seperate one.

Is it possible for you to give me some commands which can be added in the beginning or end of my recorded macro so that it runs on the rest of the files as well. I am also okay to keep the other files opened at the same time if that helps.

thanks so much for all your efforts and pain.

[HaHoBe]

Hi, rohit43,

I checked my code on one sample workbook, sheets were inserted there as expected, no error messages - after I corrected a mistake which caused a run-time error (funny it didnīt show up on your system).

Please Login or Register  to view this content.

must read

Please Login or Register  to view this content.

Please find the workbook I used for this as an attachment.

Execution is quite simple: look at the directory which is given, create a collection of all workbooks that meet the criteria in that directory, loop through all of them and insert the given number of worksheets as a copy of the one which is stated as master, clear the contents, rename them according to the array, close the workbook with saving the changes, loop until no workbook is left over.

Ciao,
Holger

[rollis13]

Cross-post: http://www.excelguru.ca/forums/showt...=7764#post7764