Hard code the link.

--
Regards,
Tom Ogilvy

"samccune" wrote in message
...

then is there a way to call data from a closed workbook?


--
samccune
------------------------------------------------------------------------
samccune's Profile:
http://www.excelforum.com/member.php...o&userid=14597
View this thread: http://www.excelforum.com/showthread...hreadid=263409