Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Sheets to a woekbook
Is there a method for copying sheets from a workbook that is not open to a
workbook that is? I have written a vba that lets a user select a number of workbooks (.FindFile method) that will open them, copy the tab (worksheet) of each workbook to the end of the target workbook, rename the new tab to the name of the file it came from, and then close the workbook. It would go a lot faster if I could get the tab from the workbook without opening it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Sheets | Excel Discussion (Misc queries) | |||
Copying sheets without copying named ranges | Excel Programming | |||
Copying Sheets | Excel Programming | |||
Copying Sheets | Excel Programming | |||
Copying sheets | Excel Programming |