ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   consolidate many workbook of 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/243855-consolidate-many-workbook-2007-a.html)

Shiv

consolidate many workbook of 2007
 
Is there an easy macro I can use to take all the workbooks in a folder and
save them as a single workbook with multiple tabs and it should be
compatable with vista ?



Ron de Bruin

consolidate many workbook of 2007
 
hi Shiv

See
http://www.rondebruin.nl/fso.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Shiv" wrote in message ...
Is there an easy macro I can use to take all the workbooks in a folder and
save them as a single workbook with multiple tabs and it should be
compatable with vista ?




All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com