Formula that refers to another workbook

I am having trouble writing a formula to another workbook. Do I need to have the workbook open before I start my formula, or can I open it while entering the formula?