useing a macro copied

[Curt]

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 = ""

 

[Jim Cone]

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 = ""

 

[Curt]

Thank you for responce. I was unaware that a macro was stored in the
document. There by I can build macro in document with no problem. Thank You
much for your responce to a novice. Stii learning