why is it that for importing data from another spreadsheet this formula works:

"=[User1.xls]Record!A2"

But,

Workbooks("User1.xls").Worksheets("Sheet1").Range("A2")

...DOESN'T WORK IN VBA?

Matts