Posted to microsoft.public.excel.programming
|
|
Import All Sheets from Closed Workbook
No you must open the workbooks
See this page
http://www.rondebruin.nl/fso.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"ryguy7272" wrote in message ...
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
|