Because elements from the worksheetfunctions class in Excel VBA can't pull
data from a closed workbook.


--
Regards,
Tom Ogilvy


"Baha" wrote in message
...
hi,
why this code always gives error anyone can help me?
Dim x As Long
x = Application.WorksheetFunction.VLookup(D7, "C:\Documents and _
Settings\BahadiAkcan\My Documents\Book1hhhfhfh.xls" & .Worksheets
_("Sheet1").Range("a1:d33"), 3, 0) _
MsgBox x
I have one more question, how can I use A1:F300 array from other file in
my
book1 without opening the file?
Thanks a lot

--
Regards,
Baha