About Us

[email protected]

Thanks a lot Dave!
Great resources!

JF

Dave Peterson wrote:
Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip

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

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

wrote:

Thanks for your answer!

I assume then that there is no way to link dynamically to a closed
workbook without using some kind of macro.

Thanks
JF

paul wrote:
=indirect() will let you reference a cell or name and return it as a proper
reference.The destination workbok must be open for it to work
--
paul

remove nospam for email addy!

" wrote:

Hi,

='C:\[Budget 2006.xls]Mysheet'!$E$12

This is OK, however, how do I control eht filename dynamically? In
other words, I want a cell that controls the filename. I haven't found
a way to do this....

--
JF

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge two files and then allowing deletion of duplicate cells?	candygrl7300	Excel Worksheet Functions	2	August 10th 06 06:23 PM
Copying Cells from CSV files in folder into one worksheet	[email protected]	Excel Discussion (Misc queries)	1	June 23rd 06 09:23 PM
need help accessing other cells within a function	mardor	Excel Worksheet Functions	0	March 30th 06 01:59 PM
Trace Dependent Cells of the Linked Files	[email protected]	Excel Discussion (Misc queries)	1	March 7th 06 01:53 AM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM

Menu

About Us