If the workbook is closed you need to add the full path

this is a cell formula not a macro

='C:\YourDirectory\[yourfile.xls]Sheet1'!A1

You may need to change sheet1 to the name of your sheet and A1 is the cell
you are looking for,

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200602/1