Simple Folder, Workbooks, Worksheets Import ?
 

From one Folder, many workbooks, single worksheet, same format,
append All non blank rows in
a single Master workbook, one worksheet. No summing, No calculations.
I need to see once for all a simple skeleton code of these loops,
using the simplest Method of FSO or Dir.
At end of this import in the Master Workbook, I need to convert the
whole B Column of Serial Dates in a proper Date format. "MM/DD/YY"
Help appreciated,
Celeste

Simple Folder, Workbooks, Worksheets Import ?
 

Hi Celeste

Start with the links in the merge section on my site

--

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


"u473" wrote in message ...
From one Folder, many workbooks, single worksheet, same format,
append All non blank rows in
a single Master workbook, one worksheet. No summing, No calculations.
I need to see once for all a simple skeleton code of these loops,
using the simplest Method of FSO or Dir.
At end of this import in the Master Workbook, I need to convert the
whole B Column of Serial Dates in a proper Date format. "MM/DD/YY"
Help appreciated,
Celeste