VBA macro to copy one sheet to all opened workbooks

[ZoranC]

Dear all,

I am trying to copy one sheet from one workbook to all opened workbooks.

Workbooks that I want to copy that sheet to are located in many different folders, but I plan to locate them all and open them all at once before copying.

Using Excel 2010, I can do that manually for each opened workbook, right click on sheet - move or copy - select ONE of the opened books... what I am tying to accomplish is equivalent to selecting ALL opened workbooks. Copied sheets could be placed at end of existing sheets.

Sheet that I want to copy to other workbooks contains links to other sheet in same workbook, but other workbooks that this sheet will be copied to already have a sheet with same name, so that is probably not a problem?

Thank you!

[Norie]

You could try this, it'll copy the active sheet to all the open workbooks except the one it's in.

Please Login or Register  to view this content.

[ZoranC]

Works like a charm!!! Thank you so much!!!