| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Import Macro
Hello here is my situation. I have a directory of excel workbooks, in each
work book it has 3 sheets. I need two pieces of data from each sheet: The outputted information in Merged cells B3-5 And The text in merged cells E-H3 The Directory that these files are in are like this : 2007/WE Sept 1/FileName.xls 2007/WE Sept 8/FileName.xls in the 2007/WE Sept 1/ directory there are about a hundred files each with a unique FileName Is there a way to open all these pull this information and have it put into one spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Excel Macro | Excel Discussion (Misc queries) | |||
| problem with import files by excel macro | Excel Discussion (Misc queries) | |||
| problem with import files by excel macro | Excel Discussion (Misc queries) | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| Import CSV files using Macro | New Users to Excel | |||
Threaded Mode
