| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import All Sheets from Closed Workbook
Is there a way to copy, or import, all sheets from a closed workbook
(workbook#1), into an open workbook? I am certain that this can be done€¦I just dont know how to do it. I viewed Ron de Bruins site, and was specifically interested in code at the following URL: http://www.rondebruin.nl/ado.htm#choose It is pretty awesome!! I am thinking there must be a way to import not only a sheet that a user chooses, but an entire workbook, with all sheets. Can this be done? If so, how so. TIA, Ryan-- -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from a closed workbook | Excel Discussion (Misc queries) | |||
| Macro to import from one closed workbook | Excel Programming | |||
| import all sheets from a closed workbook | Excel Programming | |||
| Import Sheet from Closed Workbook | Excel Programming | |||
| Using Querytable.add to import data from a closed workbook | Excel Programming | |||
Threaded Mode
