Simple Folder, Workbooks, Worksheets Import ?

[u473]

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

 

[Ron de Bruin]

Hi Celeste

Start with the links in the merge section on my site