Problem running "Save macro to all workbook in folder"

[calvinle]

Hi,

I have a workbook that a macro to run an macro into every single excel file on a folder, but it doesn't do anything when I try to run it.

I have attach the folder example..

test.zip

Thanks

[mrice]

You appear to have the comment "Assign selected folder to MyFolder" inside a string.

[Norie]

Try this.

Please Login or Register  to view this content.

[calvinle]

Great!!! Thank you very much!!

[calvinle]

But another thing. I have to insert a copyright in the bottom of each spreadsheet file. The copyright is in the Macro file in Sheet 2. When it copy to the other spreadsheet, it doesnt copy anything becuz on the 'other spreasheet' the Sheet 2 is blank. How can I force the "other spreadsheet" to add copyright that is on the Macro file?

In the macro file, I have this code:

Please Login or Register  to view this content.

This call the macro to go and copy the info in Macro-Sheet 2, and paste in Sheet 1.

Now that I am applying the macro to an external file, how can it copy from this Macro-Sheet 2?

Thanks.

[calvinle]

Any clue anyone?