Hi Jeremy
Late here, but I will post a example tomorrow after work
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Jeremy R." wrote in message ...
Ron,
I was able to get this summary code to work for me. However, when I run
this code it pulls up the Application.GetOpenFileName and has me go through
all paths, then select each individual file. (Well, I select the top file,
hold shift, and then select the bottom file...I know not to go through and
hit each one individually)
Is there a way I can just write into the code to open this set path (this
doesn't change) and select all of the workbooks in the folder without opening
the getopenfilename box. Thanks for your help.
"Ron de Bruin" wrote:
hi Jeremy
However, they are in non-adjacent cells
Try this
http://www.rondebruin.nl/summary2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Jeremy R." wrote in message ...
Thanks in advance for any help you can give me.
I have a need for a function to copy "certain data" from each file in a
folder. This folder gets bigger every week with new workbooks. The "certain
data is always in the same cells in each workbook because each file is made
from a template I created. However, they are in non-adjacent cells in my
worksheet.
I tried using some code from Ron de Bruin (http://www.rondebruin.nl/fso) but
it did not give me the results I was looking for. I was unable to figure out
the pieces of the code I need because I do not understand it all. It had to
be a range of data or all of the data. It also created a new worksheet, I
just want the data to come into the worksheet in which I ran the code.
What I need to know :
The way to run a loop through all the folders in my path.
Open or get the data from each workbook.
Copy the twelve data points I need from each one.
Place the data in a row my worksheet.
Go to the next workbook in my folder.
Copy the same twelve data points.
Find the next empty row.
Place the data in that row.
So on and so forth until all data is captured.
Any suggestions or help?