Trasnferring Specific Excel Cells into Specific Area in Word.

[dutchy316]

Hey;

Please, I am requiring great assistance...I would greatly appreciate
it if someone can help me.

I am looking for someway (probably a macro) to automatically transfer
specific cells in Excel into a specific area in Microsoft Word...the
Word document will be pre-existed documents.

There are several different cells that I need to transfer...that's
probably why I would need a macro.

I'm not too familiar with macros...that is why I'm requiring
assitance...

Thanks in advance.

S...

 

[Cindy M -WordMVP-]

Hi Dutchy316,

Since you're not well-versed in macros, I recommend the
word.vba.beginners newsgroup if you want a code solution.

However, if you copy a cell in Excel, then go to Edit/Paste Special in
Word, you can insert the cell (or its contents, depending on the format
you choose) as a link. Test this a bit, to get a feel for it.

When you have linked content in the document, Word uses a LINK field to
maintain that link. Alt+F9 will show you the field code that's used for
this.

Note that you can:
- change the path to the Excel sheet
- change the cell reference/range that you're bringing in
- break the link (Ctrl+Shift+F9) if you want static text

Depending on exactly what you need to do, you may be able to do it with
field codes without needing any macro. Or possibly a much simpler macro
(i.e. one that doesn't need to automate Excel) to adjust the field
codes and perhaps break the links.

Please, I am requiring great assistance...I would greatly appreciate
it if someone can help me.

I am looking for someway (probably a macro) to automatically transfer
specific cells in Excel into a specific area in Microsoft Word...the
Word document will be pre-existed documents.

There are several different cells that I need to transfer...that's
probably why I would need a macro.

I'm not too familiar with macros...that is why I'm requiring
assitance...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail