Auto replace between Excel and Word

B

bob

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 here: 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.
 
S

ShaneDevenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data from Excel into Word 1
How to Retrieve Historical Stock Prices? 7
How to retrieve the yahoo symbols into excel? 1
insert an Excel spreadsheet as an appendix in a Word Document 1
download info from a web site to Excel 3
Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails? 2
link word document in excel for emailing purposes 1
Historical Stock Prices in Excel 1

Top