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
Excel --> Word 4
Integrating information from Word to Excel (not mail merge) 1
Merge Excel file into Word Document 3
Linking data in MS Word into Excel 5
Word macro that can call cells out of Excel for a find and replace 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
How to retrieve the yahoo symbols into excel? 1

Top