| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Read excel workbook
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 "Frank Kabel" wrote: 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 |
|
#4
|
|||
|
|||
|
Hi
if you open the file you can replace INDIRECT.EXT with INDIRECT -- Regards Frank Kabel Frankfurt, Germany "starfighter61" schrieb im 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 "Frank Kabel" wrote: 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 |
|
#5
|
|||
|
|||
|
thanks i try that
"Frank Kabel" wrote: Hi if you open the file you can replace INDIRECT.EXT with INDIRECT -- Regards Frank Kabel Frankfurt, Germany "starfighter61" schrieb im 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 "Frank Kabel" wrote: 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 |
|
#6
|
|||
|
|||
|
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 "starfighter61" wrote: thanks i try that "Frank Kabel" wrote: Hi if you open the file you can replace INDIRECT.EXT with INDIRECT -- Regards Frank Kabel Frankfurt, Germany "starfighter61" schrieb im 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 "Frank Kabel" wrote: 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 |
|
#7
|
|||
|
|||
|
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 "starfighter61" wrote: 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 "starfighter61" wrote: thanks i try that "Frank Kabel" wrote: Hi if you open the file you can replace INDIRECT.EXT with INDIRECT -- Regards Frank Kabel Frankfurt, Germany "starfighter61" schrieb im 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 "Frank Kabel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I read Pocket Excel files from Excel | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Linear Mode
