Hello;

I would like to reference a cell in a workbook that is on a hosted server.
The following URL for instance:

http://www.chapinchristiancounseling.com/Test/test.xls

In cell A1 is Hello World. I would like to put a reference in the cell on my
local machine that would pull the information in Cell A1 into my local Cell
A1.

Does anyone know how this is done? I can't use VBA or macros for
referencing, and the information needs to update (or offer to update) every
time I open the workbook on my local. Can this be accomplished? I might try
pictures in the future, but right now I just need the text.

All of your help is greatly appreciated.

Thank You

Frank Pytel