Wanting to use INDIRECT without opening external sheet

[Walter]

I would like to use the INDIRECT function to bring in
values from another (user named) spreadsheet, however I do
not want the source spreadsheet opened.

According to HELP it needs to be opened. Is there a way to
do this without having to resort to VBA?

 

[Tom Ogilvy]

Not really.

I assume you want to use indirect because you are building the link
dynamically. If you just want to link to a closed workbook/worksheet, you
don't need indirect

='C:\Myfolder\[My workbook.xls]sheet1'!A1

Will work just fine.

Regards,
Tom Ogilvy

 

[Bob Umlas]

If you can reference it directly, without using INDIRECT, that's probably
the only way. Aside from VBA

Bob Umlas
Excel MVP

 

[Guest]

You assume correctly Tom, I would like the reference
created dynamically. How can I do it without opening the
source file?

-----Original Message-----
Not really.

I assume you want to use indirect because you are building the link
dynamically. If you just want to link to a closed workbook/worksheet, you
don't need indirect

='C:\Myfolder\[My workbook.xls]sheet1'!A1

Will work just fine.

Regards,
Tom Ogilvy

I would like to use the INDIRECT function to bring in
values from another (user named) spreadsheet, however I do
not want the source spreadsheet opened.

According to HELP it needs to be opened. Is there a way to
do this without having to resort to VBA?

.

 

[Harlan Grove]

You assume correctly Tom, I would like the reference
created dynamically. How can I do it without opening the
source file?

Only with VBA or an add-in such as Laurent Longre's MOREFUNC.XLL, which
includes a function named INDIRECT.EXT which can resolve dynamic links to
closed workbooks most of the time. It works well on my work machine running
NT4SP6 and XL97SR2, but not on my wife's PC running ME and XL2KSP3. It's
simply not possible with worksheet functionality alone.

 

[Hans Knudsen]

So far I was of the opinion that one could use the method described in
http://j-walk.com/ss/excel/eee/eee002.txt

Am I wrong?

Hans Knudsen

 

[Harlan Grove]

So far I was of the opinion that one could use the method described in
http://j-walk.com/ss/excel/eee/eee002.txt

Am I wrong?

No, but it's a VBA solution. The OP seemed to want to avoid VBA. For a fuller
discussion, see

http://www.google.com/[email protected]

 

[safaie]

hi dear
i want put data in excel without opening it
how?
thanks