View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Auto replace between Excel and Word

Hi,

I suggest that the Word newsgroup would be a much better place for that,
they are the experts on Word.

--
Thanks,
Shane Devenshire


"bob" wrote:

Hi

I would like to be able to insert live stock prices into a Word document if
I mention the ticker symbol.

For example, if I include "MSFT" in the document I would like it to be
replaced with "Microsoft down 0.4 per cent to $23.00"

I can insert the prices from Yahoo finance into Excel using useful macros
available he http://www.gummy-stuff.org/Yahoo-data.htm

Does anyone know how it would be possible to automatically insert the
prices, for the stocks that I mention, into Word?

Many thanks indeed.