Hi Kelly
is you only want to get one cell from a different workbook (probably
closed) you may have a look at the Add-In MOREFUNC.XLL
(http://longre.free.fr/english)
use the function INDIRECT.EXT.e.g.
=INDIRECT.EXT("''C:\Documents and Settings\" & cell_ref1 & "\My
Documents\My folder\[" & cell_ref2 & cell_ref3 & ".xls]Expense
Statement'!$F$2")

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

Frank

Kelly wrote:
Hi Group. I am using the Office 2000 package.

I was unable to do this with a formula so now I'm looking
for help in creating a macro that can referance an
external workbook find a value and push it to a local cell.

The workbook address and cell I want to referance needs to
be a combination of variables found in three cells in the
local work book.

So if A1=VARIABLE1 and B2=VARIABLE2 and B3=VARIABLE3

then I need the macro to access "'C:\Documents and
Settings\VARIABLE1\My Documents\My folder\[VARIABLE2 &
VARIABLE3.xls]Expense Statement'!$F$2"

And then take that value and push it to cell A1 in the
local workbook.

Any help in this would be greatly appreciated!

Kelly