Hello,
Thanks alot, I try this on a single case and it works, now i am going to
apply it on the whole, thanks for your help.

"Arvi Laanemets" wrote:

Hi


"Salman" wrote in message
...
Hi,
I already have the list of the path of every workbook, what i get is that
in
last lines you have suggested to combine text to develop the whole path
list.
If my understanding is wrong then please elaborate a little more.

Yes. But you have p.e. in cell E2 the text string
"'S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE Time Series
Data ATLH.xls]Time Series'!$A$1:$FF$220"
You have to generate some formula from this, like
=SUM('S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE Time
Series Data ATLH.xls]Time Series'!$A$1:$FF$220)

To do this for one single link:
1. Into some cell, p.e. C2, you enter the formula like
="=SUM(" & E2 & ")"
, and you get in C2 displayed
"=SUM('S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE Time
Series Data ATLH.xls]Time Series'!$A$1:$FF$220)"
NB! You don't get the link so long, and not even the string image of link -
it's only displayed so long.

2. Copy the cell C2, and overwrite the formula with its value (i.e. string),
using Paste Special Values. In C2 you get now
"=SUM('S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE Time
Series Data ATLH.xls]Time Series'!$A$1:$FF$220)"

3. With cell C2 selected, activate replace, enter equal sign into both
search and replace fields, and click Replace button. The string is converted
to formula
=SUM('S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE Time
Series Data ATLH.xls]Time Series'!$A$1:$FF$220)
, and according sum is displayed.

To do the same for all workbooks and sheets at one go, you have to design
the formula at step 1 in such a way, that by copiyng it you get all
displayed formula strings riht. And in steps 2-3 you work with range of
cells instead of single cell.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )