Read excel workbook

[starfighter61]

Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10

 

[Frank Kabel]

Hi
normally INDIRECT would do. But as the other file is probably closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")

 

[starfighter61]

Thanks alot

Yes it worked but i realised that reading 150 cells from 5 workbooks (30
cells from each) do take a long time
But if i open them it was fast.
Maybe i should open them before i use this

Hi
normally INDIRECT would do. But as the other file is probably closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")



--
Regards
Frank Kabel
Frankfurt, Germany

Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10

 

[Frank Kabel]

Hi
if you open the file you can replace INDIRECT.EXT with INDIRECT

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks alot

Yes it worked but i realised that reading 150 cells from 5 workbooks (30
cells from each) do take a long time
But if i open them it was fast.
Maybe i should open them before i use this

Hi
normally INDIRECT would do. But as the other file is probably closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")



--
Regards
Frank Kabel
Frankfurt, Germany

Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10

 

[starfighter61]

thanks i try that

Hi
if you open the file you can replace INDIRECT.EXT with INDIRECT

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks alot

Yes it worked but i realised that reading 150 cells from 5 workbooks (30
cells from each) do take a long time
But if i open them it was fast.
Maybe i should open them before i use this

Hi
normally INDIRECT would do. But as the other file is probably closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")



--
Regards
Frank Kabel
Frankfurt, Germany


starfighter61 wrote:
Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10

 

[starfighter61]

If my C5 cell have the value 44 and
i use this =INDIRECT.EXT("[Franvaro1Av" & C5 & ".xls]Sammandrag!$B$201")
it works great but if i use this
=INDIRECT("[Frånvaro1Av" & C5 & ".xls]Sammandrag!$B$201")
the cell only say #NAME

and the Franvaro1Av44.xls is open

thanks i try that

Hi
if you open the file you can replace INDIRECT.EXT with INDIRECT

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks alot

Yes it worked but i realised that reading 150 cells from 5 workbooks (30
cells from each) do take a long time
But if i open them it was fast.
Maybe i should open them before i use this

:

Hi
normally INDIRECT would do. But as the other file is probably closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")



--
Regards
Frank Kabel
Frankfurt, Germany


starfighter61 wrote:
Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10

 

[starfighter61]

Sorry it worked great
It was my swedish excel that was the trouble in there the functionname is
INDIREKT
thats often a problem

Thanks again

If my C5 cell have the value 44 and
i use this =INDIRECT.EXT("[Franvaro1Av" & C5 & ".xls]Sammandrag!$B$201")
it works great but if i use this
=INDIRECT("[Frånvaro1Av" & C5 & ".xls]Sammandrag!$B$201")
the cell only say #NAME

and the Franvaro1Av44.xls is open

thanks i try that

Hi
if you open the file you can replace INDIRECT.EXT with INDIRECT

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag Thanks alot

Yes it worked but i realised that reading 150 cells from 5 workbooks
(30
cells from each) do take a long time
But if i open them it was fast.
Maybe i should open them before i use this

:

Hi
normally INDIRECT would do. But as the other file is probably
closed
INDIRECT won't work.
See the following thread for alternatives
http://tinyurl.com/2c62u
In your case INDIRECT.EXT should work. e.g.
=INDIRECT.EXT("'L:\[Franvaro1Av" & B5 & ".xls]Sammandrag'!$H$10")



--
Regards
Frank Kabel
Frankfurt, Germany


starfighter61 wrote:
Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10