right syntax

[pls123]

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


...so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[Glenn]

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

=INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100")

 

[Dave Peterson]

The function you'd want to use is =indirect().

But =indirect() won't work if the sending file is closed.

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

That includes =indirect.ext() that may help you.

===
If you have trouble getting to the site, then search google for indirect.ext.

I found this alternative site:
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

I didn't look to see if it was the most current version.

I'd check the original site every so often to see if it's working.

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100

..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[Bob Umlas, Excel MVP]

=INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100")

 

[Jacob Skaria]

Hi "pls123"

Bob has meant to post

=INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100")

--
Jacob (MVP - Excel)

=INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100")

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[pls123]

=INDIRECT("'[ABC.xlsm]Sheet1'!" & D14 & "100")

ok it works!!
I corrected the ] you wrote instead of the '
very tx bob !

=INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100")

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[pls123]

tx all for help !!
paolo

The function you'd want to use is =indirect().

But =indirect() won't work if the sending file is closed.

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

That includes =indirect.ext() that may help you.

===
If you have trouble getting to the site, then search google for indirect.ext.

I found this alternative site:
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

I didn't look to see if it was the most current version.

I'd check the original site every so often to see if it's working.

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100

..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[Bob Umlas, Excel MVP]

oops - yes, typo. Thanks Jacob -(You new to MVP-dom?)

Hi "pls123"

Bob has meant to post

=INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100")

--
Jacob (MVP - Excel)

=INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100")

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!

 

[Jacob Skaria]

Yes Bob. (2010)

--
Jacob (MVP - Excel)

oops - yes, typo. Thanks Jacob -(You new to MVP-dom?)

Hi "pls123"

Bob has meant to post

=INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100")

--
Jacob (MVP - Excel)

=INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100")

:

hello all !
can anybody show me the right syntax for this..

='[ABC.xlsm]Sheet1'! & D14 & 100


..so it could be for example...
the cell L100 or BR100..
it depends to the value in D14

tx for help!