Thread: VBA to refer to a cell in a different file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dazman[_14_] dazman[_14_] is offline
external usenet poster
  
Posts: 1
Default VBA to refer to a cell in a different file

Hi,

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

temp = C:\Documents and Settings\Daz\Desktop\HYP Screene
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 di
as the file I'm trying to access. Can anyone point me in the righ
direction?

Cheers,

Da

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=49268

Reply With QuoteReply With Quote