Insert page into multiple workbooks

[OpieWinston]

We have multiple workbooks on a shared drive, and I want to insert the same worksheet at the beginning of all the workbooks. We're talking about probably 60+ different workbooks. Is there a way to do this without going one by one?

I use Excel 2007, but the workbooks are in the 97-03 format.

Thanks!

[JBeaucaire]

1) All workbooks ready to go in a single folder?
2) The files being opened, are they to be saved again in their original format, or updated to 2007 format?
3) You have this worksheet to insert ready to go in another workbook, yes? This workbook is NOT in the same folder, yes?

4) VBA is ok to use? A macro?

[OpieWinston]

1) Correct. All workbooks are in the same folder, and all are ready for this worksheet.
2) They will be saved in the 97-03 format.
3) The worksheet I want to insert IS ready to be inserted, and it currently IS in a workbook in the same folder. This worksheet can definitely be moved to its own workbook in a different folder if needed.
4) Only used it once, and it was a copy / paste thing. I'm not too familiar with VBA, but if you're able to walk me through implementing it, I don't see why it shouldn't work.


The way this works is we have a separate workbook for separate companies, but they are all in the same folder. The worksheet I need to put into each one is meant to be a template to use for new jobs with each company. This is a fairly new template, so as management decides tweaks need to be made, I need to be able to re-insert the correct template back into all 60+ workbooks. My hope is that it will overwrite the old one by having the same name, but I do not know if this is possible.

[JBeaucaire]

Please Login or Register  to view this content.

1) open the template workbook
2) press Alt-F11 to open the VBEditor
3) insert an empty standard code module (Insert > Module)
4) paste the code given above into the module
5) close the editor and save your template workbook in Excel 97-2003 format.

To use the macro:

1) Press Alt-F8 and select the InsertTemplate. It will open every file in the same directory and add/update the Template in each file.

[OpieWinston]

You are my hero! Thanks!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.