P
plantechbl
I have a named range "JOBDATA" (=Summary!$A$2:$K$5) in many job
specific workbooks. I have the list of the individual .XLS path and
filenames (M:\Projects\12345-Testing\12345-Testing.xls) in an overall
summary job information workbook. I need to loop through all the
individual job files and copy the "JOBDATA" named range to a
"JOB_SUMMARY" worksheet. Basically I need to "Open" the job specific
file, "Copy" the named range, "Paste Special" values into the first
empty row of the "JOB_SUMMARY" worksheet, "Close" the file without
saving, then loop through the process for the remainder of the job
files. I have checked Ron de Bruin's site
http://www.rondebruin.nl/ado.htm#files and he has some good examples
but I don't have sufficient understanding to modify them for my
application. Thanks in advance for any help.
specific workbooks. I have the list of the individual .XLS path and
filenames (M:\Projects\12345-Testing\12345-Testing.xls) in an overall
summary job information workbook. I need to loop through all the
individual job files and copy the "JOBDATA" named range to a
"JOB_SUMMARY" worksheet. Basically I need to "Open" the job specific
file, "Copy" the named range, "Paste Special" values into the first
empty row of the "JOB_SUMMARY" worksheet, "Close" the file without
saving, then loop through the process for the remainder of the job
files. I have checked Ron de Bruin's site
http://www.rondebruin.nl/ado.htm#files and he has some good examples
but I don't have sufficient understanding to modify them for my
application. Thanks in advance for any help.