Making a Call to an external sheet using a variable...

[edwrobis]

Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!

 

[Bernard Liengme]

try this =INDIRECT("[Name"&A1&"]Sheet!A1")
the NameNN file must be open
If you want to work with closed files Laurent Longre has an addin
(morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.

 

[edwrobis]

So in using the Indirect function ... would it be possible to make a
call to a document using this type of code?

=IF(Attendence!B6="", "", '[Mail ExportXXX.xls]Sheet1'!$H4)

Where the xxx is a variable number that will change per a value placed
somewhere else in the sheet?

try this =INDIRECT("[Name"&A1&"]Sheet!A1")
the NameNN file must be open
If you want to work with closed files Laurent Longre has an addin
(morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!