Hi all,
Just a small problem but it would be great if someone could solve it.
I know how to import data from a worksheet that is in the same excel
file, for example, I want to import the contents of cell C3:
=worksheetName!C3

But how can I do the same thing if I am importing from a different
excel file?
It works for me in so much that it will prompt me to find the
datasource, but this is a painstaking process as, every time I open my
excel file, it asks me to update values, and I have to search for the
escel file each time.

Surely you can say something like:
C:\Documents and Settings\profileName\Desktop\Folder1\worksheetName !C3

I know the syntax above is probably wrong, but does anyone know how to
do it?

Thanks in advance,

Steve


--
drumcode
------------------------------------------------------------------------
drumcode's Profile: http://www.excelforum.com/member.php...o&userid=35170
View this thread: http://www.excelforum.com/showthread...hreadid=549386