Simple Folder, Workbooks, Worksheets Import ?

U

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested Import Loops 3
Re-Format from Text to Number & Consolidate multiple Workbooks 1
HELP => VBA Code To Import Worksheets Into A WorkBook 7
Excel 2011 Mac - Import Worksheets into a Single File 0
Creating a unique list of Cost Codes in Col. A from all worksheets in all workbooks in folder X 1
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Command Button to import worksheets 1
Create Workbooks and then create Worksheets within them 2

Top