| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Import Macro
Start on my site gkarasiewicz
You can find a add-in and code This is the link to the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Import Macro
Hello
I have tried to install this however it says that it's not a valid add-in. Perhaps it's that i'm on a network and dont' have the necessary system rights. So this option could have been and option had it worked on our system. Is there a code version that i can compile on my end and try that? "Ron de Bruin" wrote: Start on my site gkarasiewicz You can find a add-in and code This is the link to the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Import Macro
See the links to the code pages on the bottom of the page
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... Hello I have tried to install this however it says that it's not a valid add-in. Perhaps it's that i'm on a network and dont' have the necessary system rights. So this option could have been and option had it worked on our system. Is there a code version that i can compile on my end and try that? "Ron de Bruin" wrote: Start on my site gkarasiewicz You can find a add-in and code This is the link to the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Import Macro
I've never coded in Excel like that, do you have code for capturing the
information from open workbooks? "Ron de Bruin" wrote: See the links to the code pages on the bottom of the page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... Hello I have tried to install this however it says that it's not a valid add-in. Perhaps it's that i'm on a network and dont' have the necessary system rights. So this option could have been and option had it worked on our system. Is there a code version that i can compile on my end and try that? "Ron de Bruin" wrote: Start on my site gkarasiewicz You can find a add-in and code This is the link to the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Import Macro
I've never coded in Excel like that, do you have code for capturing the
information from open workbooks? No, i always open the books with code Download the example workbook from my FSO page and let me know if you have problems http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... I've never coded in Excel like that, do you have code for capturing the information from open workbooks? "Ron de Bruin" wrote: See the links to the code pages on the bottom of the page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... Hello I have tried to install this however it says that it's not a valid add-in. Perhaps it's that i'm on a network and dont' have the necessary system rights. So this option could have been and option had it worked on our system. Is there a code version that i can compile on my end and try that? "Ron de Bruin" wrote: Start on my site gkarasiewicz You can find a add-in and code This is the link to the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gkarasiewicz" wrote in message ... 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? |
| Reply |
| 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 | |||
Linear Mode
