Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 04, 05:29 PM
starfighter61
 
Posts: n/a
Default 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   Report Post  
Old October 27th 04, 05:36 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old October 27th 04, 10:57 PM
starfighter61
 
Posts: n/a
Default

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   Report Post  
Old October 27th 04, 11:00 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old October 27th 04, 11:11 PM
starfighter61
 
Posts: n/a
Default

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   Report Post  
Old October 28th 04, 12:01 AM
starfighter61
 
Posts: n/a
Default

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   Report Post  
Old October 28th 04, 10:47 AM
starfighter61
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I read Pocket Excel files from Excel billywhizz Excel Discussion (Misc queries) 0 January 23rd 05 06:47 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 07:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017