Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a unique list of Cost Codes in Col. A from all worksheets in all workbooks in folder X | Excel Programming | |||
Copy & Paste Range from all Worksheets in all Workbooks in a folder | Excel Programming | |||
Import Data from 2 Workbooks in the same folder | Excel Programming | |||
how can i import worksheets from multiple workbooks | New Users to Excel | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming |