That is the way the world is (at least in Microsoft's version).
Each office program uses it's own objects, properties, methods and constants
with very little overlap.
Code for Word will not work in Excel and vice versa.

Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Curt"
wrote in message
Someone tried to respond to this link will not open. I tried google stumped
HELP
copy a macro over to run from vba in Excel works fine in word. When try from
excel will not go to printer
following is code this is only part. Have noticed that .destination all ways
goes to small not caps
Thanks to all

With ActiveDocument.MailMerge
'.Application = ActivePrinter
.destination = wdSendToPrinter error 5852 required object not available
' Application = ActivePrinter
'ActiveSheet.PrintOut
.MailAsAttachment = False
.MailAddressFieldName = ""