using cell's contents instead of file name

A

AlexD

Please, advise whether it's possible to use a cell's
contents instead of a file name.

If I have "SSS" in A1, how could I use it instead of the
FileName in the path reference such
as 'C:\Path\[FileName.xls]Sheet1'!$B$25 that FileName
would reflect SSS and it would be [SSS.xls]

Using Cell("contents",A1) as
'C:\Path\[Cell("contents",A1).xls]Sheet1!$B$25 isn't
working.

Thanks
 
F

Frank Kabel

Hi
normally using INDIRECt would work.
e.g.
=INDIRECT("'[" & A1 & "]Sheet1'!B25")

But this won't work for closed workbooks.
Alternatives:
If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g. (if cell A1 stores the reference)
use:

=INDIRECT.EXT("'c:\path\[" & A1 & "]Sheet1'!B25")

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u
 
A

AlexD

Thanks a lot, Frank.
It's working with an opened workbook.
Thanks for the link to work with an opened workbook, but I
couldn't install MOREFUNC.
I'm getting the following error message:

Extracting Morefunc.cnt
Extracting Morefunc.hlp
CRC failed in Morefunc.hlp
Unexpected end of arcive

Alex
-----Original Message-----
Hi
normally using INDIRECt would work.
e.g.
=INDIRECT("'[" & A1 & "]Sheet1'!B25")

But this won't work for closed workbooks.
Alternatives:
If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g. (if cell A1 stores the reference)
use:

=INDIRECT.EXT("'c:\path\[" & A1 & "]Sheet1'!B25")

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u



--
Regards
Frank Kabel
Frankfurt, Germany

Please, advise whether it's possible to use a cell's
contents instead of a file name.

If I have "SSS" in A1, how could I use it instead of the
FileName in the path reference such
as 'C:\Path\[FileName.xls]Sheet1'!$B$25 that FileName
would reflect SSS and it would be [SSS.xls]

Using Cell("contents",A1) as
'C:\Path\[Cell("contents",A1).xls]Sheet1!$B$25 isn't
working.

Thanks
Click to expand...
.
Click to expand...
 
F

Frank Kabel

Hi
I would contact Laurent (his address should be on his Website)

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks a lot, Frank.
It's working with an opened workbook.
Thanks for the link to work with an opened workbook, but I
couldn't install MOREFUNC.
I'm getting the following error message:

Extracting Morefunc.cnt
Extracting Morefunc.hlp
CRC failed in Morefunc.hlp
Unexpected end of arcive

Alex
-----Original Message-----
Hi
normally using INDIRECt would work.
e.g.
=INDIRECT("'[" & A1 & "]Sheet1'!B25")

But this won't work for closed workbooks.
Alternatives:
If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g. (if cell A1 stores the reference)
use:

=INDIRECT.EXT("'c:\path\[" & A1 & "]Sheet1'!B25")

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks):
http://tinyurl.com/2c62u



--
Regards
Frank Kabel
Frankfurt, Germany

Please, advise whether it's possible to use a cell's
contents instead of a file name.

If I have "SSS" in A1, how could I use it instead of the
FileName in the path reference such
as 'C:\Path\[FileName.xls]Sheet1'!$B$25 that FileName
would reflect SSS and it would be [SSS.xls]

Using Cell("contents",A1) as
'C:\Path\[Cell("contents",A1).xls]Sheet1!$B$25 isn't
working.

Thanks
Click to expand...
.
Click to expand...
Click to expand...
 
Top