temp = workbooks("HYP Screener
v11.xls").Worksheets("ShareData").Range("L3")

this will require the workbook to be open


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dazman" wrote in
message ...

Hi,

Really stupid question, but I'm not sure of the syntax to refer to a
cell in another worksheet from within VBA. I'm trying:

temp = C:\Documents and Settings\Daz\Desktop\HYP Screener
v11.xls[ShareData]!L3

or

temp = '[HYP Screener v11.xls]ShareData'!L3

and neither seems to work. The file I'm working on is in the same dir
as the file I'm trying to access. Can anyone point me in the right
direction?

Cheers,

Daz


--
dazman
------------------------------------------------------------------------
dazman's Profile:
http://www.excelforum.com/member.php...o&userid=25903
View this thread: http://www.excelforum.com/showthread...hreadid=492683