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.
|