software

Hi,

i was wondering if the following could be achieved?
i have approx 600 excel books all created from a master template. originally
they were named indiviually as 1234 (job number) amp; quot;Quotes amp; Ordersquot;.xls
where later i renamed the template to Quote book giving me job number and
quote book.
example: 1234 Quote Book.xls
the excel books are found in various client folders in 1 parent folder named
quot;Clientsquot; in my Company Shared folder on my server.
i need to retrieve ALL specific data from ALL of these books and place in
list form in a single book. the data is found as follows in all books:

Client Name = C1
Job No = C2
Description = C3
Project Date = C4
Job Value = E36
Total Spend = E33
Quoted Hrs = L19
Actual Hrs = M19

Can the be achieved? basically, i will need something to look through the
complete folder, filter out all of these books and retrieve the data.

thanks in advance,

Nigel

You might get a quicker answer if you post this to
microsoft.public.excel.programming

quot;Nigelquot; wrote:

gt; Hi,
gt;
gt; i was wondering if the following could be achieved?
gt; i have approx 600 excel books all created from a master template. originally
gt; they were named indiviually as 1234 (job number) amp; quot;Quotes amp; Ordersquot;.xls
gt; where later i renamed the template to Quote book giving me job number and
gt; quote book.
gt; example: 1234 Quote Book.xls
gt; the excel books are found in various client folders in 1 parent folder named
gt; quot;Clientsquot; in my Company Shared folder on my server.
gt; i need to retrieve ALL specific data from ALL of these books and place in
gt; list form in a single book. the data is found as follows in all books:
gt;
gt; Client Name = C1
gt; Job No = C2
gt; Description = C3
gt; Project Date = C4
gt; Job Value = E36
gt; Total Spend = E33
gt; Quoted Hrs = L19
gt; Actual Hrs = M19
gt;
gt; Can the be achieved? basically, i will need something to look through the
gt; complete folder, filter out all of these books and retrieve the data.
gt;
gt; thanks in advance,
gt;
gt; Nigel

See
www.rondebruin.nl/copy3.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;Nigelquot; gt; wrote in message ...
gt; Hi,
gt;
gt; i was wondering if the following could be achieved?
gt; i have approx 600 excel books all created from a master template. originally
gt; they were named indiviually as 1234 (job number) amp; quot;Quotes amp; Ordersquot;.xls
gt; where later i renamed the template to Quote book giving me job number and
gt; quote book.
gt; example: 1234 Quote Book.xls
gt; the excel books are found in various client folders in 1 parent folder named
gt; quot;Clientsquot; in my Company Shared folder on my server.
gt; i need to retrieve ALL specific data from ALL of these books and place in
gt; list form in a single book. the data is found as follows in all books:
gt;
gt; Client Name = C1
gt; Job No = C2
gt; Description = C3
gt; Project Date = C4
gt; Job Value = E36
gt; Total Spend = E33
gt; Quoted Hrs = L19
gt; Actual Hrs = M19
gt;
gt; Can the be achieved? basically, i will need something to look through the
gt; complete folder, filter out all of these books and retrieve the data.
gt;
gt; thanks in advance,
gt;
gt; Nigel
Hi all,

i have re-posted this in Excel Programming for further solutions.Thanks,Nigel

quot;Ron de Bruinquot; wrote:

gt; See
gt; www.rondebruin.nl/copy3.htm
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Nigelquot; gt; wrote in message ...
gt; gt; Hi,
gt; gt;
gt; gt; i was wondering if the following could be achieved?
gt; gt; i have approx 600 excel books all created from a master template. originally
gt; gt; they were named indiviually as 1234 (job number) amp; quot;Quotes amp; Ordersquot;.xls
gt; gt; where later i renamed the template to Quote book giving me job number and
gt; gt; quote book.
gt; gt; example: 1234 Quote Book.xls
gt; gt; the excel books are found in various client folders in 1 parent folder named
gt; gt; quot;Clientsquot; in my Company Shared folder on my server.
gt; gt; i need to retrieve ALL specific data from ALL of these books and place in
gt; gt; list form in a single book. the data is found as follows in all books:
gt; gt;
gt; gt; Client Name = C1
gt; gt; Job No = C2
gt; gt; Description = C3
gt; gt; Project Date = C4
gt; gt; Job Value = E36
gt; gt; Total Spend = E33
gt; gt; Quoted Hrs = L19
gt; gt; Actual Hrs = M19
gt; gt;
gt; gt; Can the be achieved? basically, i will need something to look through the
gt; gt; complete folder, filter out all of these books and retrieve the data.
gt; gt;
gt; gt; thanks in advance,
gt; gt;
gt; gt; Nigel
gt;
gt;
gt;