I am also trying to do the same thing. I have been playing around with
hlookup. How do i go about making my new spread sheet pull the
information from a document on a server? My formula seems to work but
only if you open the document.

Is it easyer to do this with macros and how would i go about it.


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=378986