Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a sheet into multiple workbooks
I have 500+ identical single-sheet workbooks in a folder and would like to
insert a sheet from another workbook into all of them. Is there a way to do this in a batch w/o have to open each one and copying the sheet? Thanks. spence |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a sheet into multiple workbooks
Hi Spence,
If you are familiar with VBA you can write a module to what you are asking. The DIR function is very useful. You can load an array with all the excel workbook path+names in a given folder i.e.: MyFile = Dir(MyPath + "\*.xls") ' Load an array with all .xls file names found in the given path aFileArray(1) = MyPath + "\" + MyFile For i = 2 To 500 MyFile = Dir If MyFile < "" Then aFileArray(i) = MyPath + "\" + MyFile ElseIf MyFile = "" Then Exit For End If Next i Then recursively open each one and paste your worksheet. Regards. "spence" wrote: I have 500+ identical single-sheet workbooks in a folder and would like to insert a sheet from another workbook into all of them. Is there a way to do this in a batch w/o have to open each one and copying the sheet? Thanks. spence |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a sheet into multiple workbooks
Hi spence
Try this one http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "spence" wrote in message ... I have 500+ identical single-sheet workbooks in a folder and would like to insert a sheet from another workbook into all of them. Is there a way to do this in a batch w/o have to open each one and copying the sheet? Thanks. spence |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference the same row from another sheet after inserting a new ro | Excel Worksheet Functions | |||
Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |