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