Sorry I should also have specified that I want to avoid the use of macros.

"Kristian G" wrote:

I need to import a cell values from an un-opened .xls using a variable address
ie
cell A34 = the location of the .xls on our server
(j:\121213\Drafting\Quants\)
"105 White Ant" = the name of the .xls
B3 = the cell I need to import

C6 = value(A34+"105 White Ant"+B3)

Any help or advice would be hugely appriciated