Copy & Paste between Excel & Word in a Macro?

[joan in AZ]

I need to create a macro to
copy data from an excel sheet
into sections of word documents

I would normally use paste-link,
however the docs are all in txt format.
(The docs are actually text commands
that are later fed to another system.)

When I record a macro in excel, the macro
seems to stop when I switch to word.

Any help is greatly appreciated.
Thanks!!!
-Joan

 

[Beth Melton]

You can't record this type of macro but you can use VBA.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/