Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing entire workbooks
I am unable to find a tool to import an entire workbook file into a master
file. I assume that I will have to write a macro to Select All on the worksheets in the source and somehow copy the worksheets and paste them into the master. I can easily write my own macro to move the tables from one file to the master, but my charts will get messed up in the move. I was hoping to just find a macro to move my chart tabs and data tabs in one big swoop. Any suggestions? am I missing something obvious. worksheet consolodation doesn't seem to apply. I have 120 files that I need to squish into 5 or 8 master fills. Each file has 4 worksheets, 2 data, 2 charts. Thanks for the suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing entire workbooks
I think I figure it out, I just need to loop this with each filename.
Sub mvall() ' ' mvall Macro ' Macro recorded 8/7/2006 by ggggg ' 'current = ActiveWorkbook.Name Windows([current]).Activate Worksheets.Select Worksheets.Move Befo=Workbooks("masterc1.xls"). _ Sheets(2) Charts.Select Charts.Move Befo=Workbooks("masterc1.xls"). _ Sheets(2) End Sub "fugazi48" wrote: I am unable to find a tool to import an entire workbook file into a master file. I assume that I will have to write a macro to Select All on the worksheets in the source and somehow copy the worksheets and paste them into the master. I can easily write my own macro to move the tables from one file to the master, but my charts will get messed up in the move. I was hoping to just find a macro to move my chart tabs and data tabs in one big swoop. Any suggestions? am I missing something obvious. worksheet consolodation doesn't seem to apply. I have 120 files that I need to squish into 5 or 8 master fills. Each file has 4 worksheets, 2 data, 2 charts. Thanks for the suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing data from other workbooks | Excel Discussion (Misc queries) | |||
importing csv files- entire record goes into each column | Excel Discussion (Misc queries) | |||
Importing Modules From Other Workbooks | Excel Programming | |||
Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) |