Hi,
the text elements at the beginning at the end must be surrounded by the "-sign (shift-2).

In your case:
="'C:\[calc"&B1&".xls]Page1'!A1"

I tried it out and that should work for you I hope!