Posted to microsoft.public.excel.programming
|
|
Consolidating spreadsheets
Thanks!!!
Ron de Bruin wrote:
Hi Jess
See this page
http://www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Jess" wrote in message oups.com...
Does anyone have an easy code to consolidate all workbooks within a
specified folder?
Create new workbook
Get contents of workbook1
Paste into new workbook
Get contents of workbook2
Paste under contents of workbook 1 in new workbook
Get contents of workbook3....
Until there are no more workbooks in that folder.
|